Generate SSRS Report using SSIS

[Pramod Jamadagni]

Hi,

Attached are ssis pkg, config file and create sql job script to render ssrs reports,

Things this SSIS pkg can do:,

1.       Provide values upto 6 paramaters for SSRS.

2.       Send individual mails or consolidated mails with reports as attachements(pdf/Excel).

3.       Disable send mail option so that only reports can be generated and stored in a folder specified.

Prerequisites:

1.       Changed the url to point to access the report. The character & in the url should be suffixed with & as shown in the example

http://2003srv-upscom/ReportServer/Pages/ReportViewer.aspx?%2fDEV_Reports%2fClassList_Report&rs:Command=Render

2.       The sql query should return all the column as varchar. Even if the column has null put is as 'Null'.

3.       Change the connection string to specify the database where the query has to run.

4.       Param_* contains the parameter name in the rdl file.

Eg. Param_1 = ClassOf means the first parameter is having parameter name “ClassOf” in the rdl file(not display name).

 

Hope this will be of some help to you guys J readymade solution

 

Thanks,

---

Pramod Jamadagni,

Indecomm global services - Technology division,

#10, Brigade south parade,

MG Road, Bangalore - 560001.