locked
Is it possible to Execute a SSIS 2005 package, that triggers a SSRS2008R2 report to execute RRS feed

  • Question

  • Hi there,

    I am trying to execute an SSRS2008R2 report from an SSIS 2005 package.   Is this even possible???

    I seem to have tested everything, but can't seem to get it working.

    The web service Task in SSIS does allow me to connect to the web service and download the WSDL file locally, however it seems that I can not properly set the parameters needed for report, in addition to the Render method not being available.     Through google, I read that the Download WSDL feature actually produces incorrect file, as opposed to a copy of the server file.    Is this correct?

    The second option that I tested was using a Script Task to connect to the web service.    It seems I can connect t the web service, but I am not able to pass the paramaters needed for report properly..In addition, through google, seems the script task does not support web references as it is VSA...Is there any kind of workaround I can use with this environment?

    My next test, is to try and create an "expired" subscription on the ReportServer.   It is my understanding that creating a subscription will create a job that can then be called upon by the SSIS Execute Job task....  This is my last result, so I hope it works....

    If somebody could provide some input on the above, that would be greatly appreciated.    If any of the above options are workable, I will provide my coding for some additional help.

    JFoug

    Tuesday, March 26, 2013 7:20 PM

Answers

  • A good place to start is an article and a white paper in it: http://siddhumehta.blogspot.ca/2010/06/ssis-and-ssrs-integration-for.html and then http://msbimentalist.wordpress.com/2011/12/27/execute-ssrs-report-from-ssis-package/

    Arthur My Blog

    • Marked as answer by Eileen Zhao Tuesday, April 2, 2013 8:51 AM
    Tuesday, March 26, 2013 8:19 PM