Learn how to call SSRS Reports in SSIS Package (Export from Reporting Services or Local RDL files). Check this link http://zappysys.com/products/ssis-powerpack/ssis-report-generator-task/

=============================================
This video covers
=============================================
◾ Export SSRS reports from server
◾ Export SSRS reports from SharePoint
◾ Export SSRS reports in local mode (*.rdl file) without need of server
◾ Export SSRS reports data-driven mode using config table

=============================================
SSIS Reporting Services Task (SSIS Report Generator Task)
=============================================
SSIS Report Generator Task can be used to export or email SSRS reports inside SSIS Package. This task also supports dynamic data driven export which can export several reports to disk and email to specified users based on settings stored in sql table.

Features
◾Automate reporting services report export and email process using SSIS.
◾Support for SSRS 2005/2008/2012.
◾Support for Local report which requires no connectivity to SSRS server, just provide rdl file and runtime connection to export report.
◾Support for Sharepoint Integrated Mode.
◾Export report in xls, pdf, doc, xml, mhtml and csv format
◾Send report as attachment to list of users
◾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
◾Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit)