CODEWITHSUNDEEP
reporting-servicesssis
dirtyw0lf
dirtyw0lf

Reputation: 1958

Using an SSRS Dataset as a source for SSIS

Is it possible to use an SSRS dataset query file as an SQL expression in SSIS for importing data? I am looking to reduce report run-time and would like to prepare the dataset's data in advance without having to duplicate the query in SSIS. Thanks DW

Upvotes: 1

Views: 1319

Answers (1)

Jason Horner
Jason Horner

Reputation: 3690

I'm not sure if you really want to go from SSRS to SSIS or vice versa.

If the intent is to preprocess data in SSIS for rendering in a report (Think real-time EII) then have a look at: Configuring Reporting Services to Use SSIS Package Data

if instead you want to go from SSRS Into SSIS. I would execute the report and store the output to the files system. then pick upo the resulting file from SSIS. see this link for more info: File Share Delivery in Reporting Services

Another potential option is to use the SSRS Web service api or directly pull a cached or snapshot report execution out of either the ReportServerTempDB or the ReportServerDB respectively though this is probably overkill.

The approach smells a bit wrong almost as if you are using SSRS as the ETL tool. I'd like to hear more about why you are going this route.

Upvotes: 2

Related Questions