Thursday, June 21, 2012

Use SSIS package data as source for Report in Reporting Services

It is possible to use the destination output of a Package in SSIS as the input source of a report in Reporting Services. In SSIS the package can send output to a datareader destination object, this in memory output can then be captured by Reporting Services.

Configuring Reporting Services to Use SSIS Package Data

There is an article on MSDN that describes the configuration and also warns about possible security risks.

Creating Report Datasets from SQL Server Integration Services

The follow-up explains how to create a package and a report

1 comment:

Anonymous said...

I like the valuable info you provide in your articles.

I'll bookmark your weblog and check again here regularly. I am quite sure I will learn plenty of new stuff right here! Best of luck for the next!

Feel free to visit my blog post; real online jobs