ssrs.vwOnPipeLineRowsSent and ssrs.ParsePipeline

Nov 12, 2009 at 5:04 PM
Edited Nov 12, 2009 at 5:25 PM

Hello,

where I can find the ssrs.vwOnPipeLineRowsSent and ssrs.ParsePipeline object?

Or the script for the view and the function?

The DataFlow Task in LoadFact.dtsx need this object.

Thanks in advance

Alex

Nov 27, 2009 at 11:50 PM

Those objects were created with the install of the 2005 SSISEventLogReportPack
(sample reports from Microsoft: http://www.microsoft.com/downloads/details.aspx?FamilyId=D81722CE-408C-4FB6-A429-2A7ECD62F674&displaylang=en )

Or instead of digging through the install files, the code with some helpful commentary is in a Brian Knight post here:
http://pragmaticworks.com/community/blogs/brianknight/archive/2008/11/28/parsing-the-onpipelinerowssent.aspx

Just create the ssrs schema, the ParsePipeline function and the vwOnPipeLineRowsSent view.  Then you should be set.