Viewing 2 posts - 1 through 2 (of 2 total)
Hi,
Yes you can use SSIS Script task to create SSRS reports, refer link below for more information on how to call SSRS reports using VB,
http://www.tek-tips.com/faqs.cfm?fid=5918
Then you can use...
May 10, 2008 at 6:50 am
#813457
You can set TransactionOption property of Data Flow task or package and use transaction (you can rolled back in case of failuare)
Omkar.
October 21, 2007 at 6:43 am
#743932