Wednesday, March 7, 2012

RS Execution Log and SQL 2005

Hello All,
SQL 2000 Reporting Services came with a DTS package that could be configured
to collect data daily on Report Execution. The results were then stored in a
RSExecutionLog database. Is this functionality still supported in 2005
Reporting Services?Well, for RS 2005 it is not a DTS package, it is a Integration Services
package. I was trying to get this working and I did not have Integration
Services installed (which requires reinstalling all service packs). So I
delayed until I had some time to install it.
Bruce Loehle-Conger
"EFrayer@.community.nospam"
<EFrayercommunitynospam@.discussions.microsoft.com> wrote in message
news:9F060287-4EAF-4FBD-9DA8-A1192674999E@.microsoft.com...
> Hello All,
> SQL 2000 Reporting Services came with a DTS package that could be
> configured
> to collect data daily on Report Execution. The results were then stored
> in a
> RSExecutionLog database. Is this functionality still supported in 2005
> Reporting Services?|||Can I get a little more information on how to do this? Where can I find this
Integration Services package that you are taking about?
"Bruce L-C [MVP]" wrote:
> Well, for RS 2005 it is not a DTS package, it is a Integration Services
> package. I was trying to get this working and I did not have Integration
> Services installed (which requires reinstalling all service packs). So I
> delayed until I had some time to install it.
> Bruce Loehle-Conger
> "EFrayer@.community.nospam"
> <EFrayercommunitynospam@.discussions.microsoft.com> wrote in message
> news:9F060287-4EAF-4FBD-9DA8-A1192674999E@.microsoft.com...
> > Hello All,
> > SQL 2000 Reporting Services came with a DTS package that could be
> > configured
> > to collect data daily on Report Execution. The results were then stored
> > in a
> > RSExecutionLog database. Is this functionality still supported in 2005
> > Reporting Services?
>
>

No comments:

Post a Comment