Hello,

I am well with ssrs from from ssis. I have already worked with this. Here I would like to mention some steps that includes that how to call SSRS report from ssis.

1.Automate reporting services report export and email process using SSIS.

2.Support for SSRS 2005/2008/2012.

3.Support for Local report which requires no connectivity to SSRS server, just provide rdl file and runtime connection to export report.

4.Support for Sharepoint Integrated Mode.

5.Export report in xls, pdf, doc, xml, mhtml and csv format

6.Send report as attachment to list of users

7.Support for Data Driver export process. You can configure reports, recipients, file format and many other options inside Database table to drive your automated export process

8.Support for SQL Server 2005, 2008, 2012, 2014 (32 bit and 64 bit).

We are having complete package of this. I think this will be helpful. More more info you can follow call ssrs from ssis.[/url]