Hello,

I have solution of this query, that How to Call SSRS Report from SSIS[/url] . I have complete package of this task where You will get the the sample work with source code. Package has following functionality that will be helpful for you.

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.You can export report in xls, pdf, doc, xml, mhtml and csv format

5.Send report as attachment to list of users

6.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

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

To see complete detail follow this link

http://zappysys.com/products/ssis-powerpack/ssis-report-generator-task/

🙂