Download Source Files: Here This is the first of four posts looking at how to generate and save SSRS reports from within SSIS. In this post I will look at creating the stored procedure to retrieve the report information, and creating and deploying the sample report to the report server. The Second post will look at a method of calling to the report server and generating reports in the control flow of SSIS. We’ll look at how to connect to the web service, pass parameters and save a report to disk. The third post in this series will show how to do the same thing in Data Flow, but instead of writing the reports out to disk I’m going to save the reports in a binary format straight to the database. The fourth post in this series will show you how to use SSIS to retrieve the binary files saved in SQL server and render them back to disk. I’ll also illustrate in this example how you can attach the files to an email and send them. I hope that at the end of thi...
