Executing Reporting Services thru SSIS

Last Post 09 Jul 2009 11:51 AM by CraigYellick. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

20 Feb 2009 08:33 AM
Can someone please tell me if there is a way to execute an SQL report in Reporting Services thru an SSIS package?

Thank You
New Member
New Member

09 Jul 2009 11:51 AM
Late reply... just noticed your February question in July.

SQL Reporting Services is driven by a web service, so an SSIS package could call the SQL RS web service to accomplish pretty much anything that is possible with RS. Use of the web service is more complicated than can be accomplished with the SSIS web service task, so you'll probably want to use a Script task.

Acceptable Use Policy