July 8, 2008 at 7:46 pm
HI All,
I am new to SSIS. I have a SSIS package which executes report services report and renders them as PDF. The parameter for the report execution are fed from a database table. The volume of PDF generated is 1300.
Now I have a requirement to email these to clients, whose parameter are again from a different tables. I know I can email these pdf , but I downside of using SQL SEVER 2005 and send mail task through SSIS. If anybody has done this before could you please share your thoughts.
Thanks,
Bala
July 9, 2008 at 6:28 am
If you are using the Enterprise Edition of SQL Server Reporting Services, what you are describing is a data-driven subscription and you don't need SSIS at all. A data-driven subscription will run a report based on parameters specified in a query and also distribute the report (via email if you want) based on the query.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply