[Update: 2009-12-30]
We got it working using SSIS. Read this post: http://geekswithblogs.net/LifeLongTechie/archive/2009/12/08/final-note-on-creating-pdf-using-ssrs-and-ssis.aspx
[Original post]
Would love to know if there is a way to kick off a SSRS report and pass some parameters into it via T-SQL or SSIS. Unfortunately, we can't have MS SQL Enterprise edition.
Guess this is the true list of possible solutions:
- VB script
- PowerShell
- WMI script
- batch file
- T-SQL
Sad thing is I know how to make this work with Crystal report, and I hope I can find a similar API for SSRS to make this work. Any help is greatly appreciated.
[Update: 2009-12-01]
Looks like this is very promising: http://ryanfarley.com/blog/archive/2006/01/27/15689.aspx
Using script task to get it: http://www.tek-tips.com/faqs.cfm?fid=5919
Looks like the way to go is build with SSIS, use script component to call for each parameter.