Using SSIS to republish SSRS reports in bulk

MSDN has recently published an article that explains how to update parameterized SQL Server Reporting Services (SSRS) reports in bulk by using a SQL Server Integration Services (SSIS) package.

The article, Bulk Report Generation using SSIS and SSRS 2008 R2, was written for MSDN by By Siddharth Mehta, Senior Technical Consultant for Business Information Management unit at Capgemini India Private Limited (Mumbai branch). You can read Siddharth Mehta’s blog about Microsoft BI at http://siddhumehta.blogspot.com, and you can contact him at siddhumehta_brain@yahoo.co.in.

The solution uses the SSIS Script Component to call the SSRS API and supply the parameters required to regenerate one report after another.

Comments on my blog are disabled, but you can still email me

Deleting the flood of spam comments simply got to be too much. But please don't hesitate to contact me at dougbert at dougbert.com.

Thank you for following!