need to automate the RDLC reporting through SSIS script task?

Question

Hello All,

Currently I'm calling RDLC report in asp.net application, where .rdlc is calling and we passing a data source and report in generated as PDF, the entire process initiate on a BUTTON click and report is generate.

Now this process need to automate and report should generate on Monday morning.

There is some suggestion come out that we can use SSIS Script Task and we can call external DLL and can call .rdlc file too to generate the report and then we can schedule SSIS package?

I never having experience on SSIS side, need your suggestion and how to do that, if there is possibilities? Thank You!

Answer 1

here is how you reference an assembly/dll in a SSIS Script Task

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Answer 2

This is an example how to call SSRS from SSIS, it creates an output of HTML but changing the parameter it can be easily adapted to return a PDF.

http://randypaulo.wordpress.com/2011/10/27/ssrs-calling-reporting-services-using-wcf-and-using-the-html-output-for-email-notification/

---

Randy Aldrich Paulo

MCTS(BizTalk 2010/2006,WCF NET4.0), MCPD | My Blog

BizTalk Message Archiving - SQL and File
Automating/Silent Installation of BizTalk Deployment Framework using Powershell >
Sending IDOCs using SSIS