SSRS and SSIS and Reporting Studio Services Package

Scenario - I have created a SSRS Report that is dependent on an Integration running first. A report can be run out of another system at any time and saved. Right now I'm manually executing the Integration Package after running the report and saving it as a specific file. Then I execute the Integration Package and then I run a bigger report that combines data from the external report along with the data in my database. The database I'm using is refreshed with new data everyday.

I'm wondering if there is a possibility to add to a Reporting Services package the integration package?

Popular White Paper On This Topic

I am having some trouble following your scenario. From what I understand, you are trying to source data from an SSRS Report, store it as a dataset, and then integrate the dataset with another system as a source for a secondary SSRS Report? Can you please explain how SSRS Report 1 is dependent on an Integration Package? Will it fail if the SSIS package did not execute, or is it that the data will not be accurate?

If you have access to the source query in the SSRS Report, you can use that as a source in your SSIS package, you will need to apply any logic that takes place in the report to the query though.