Adding a VSTA Script task programmatically (revised)

[UPDATED WITH A BETTER CODE SAMPLE FOR THE 2ND SCENARIO TUE 6/10/08] The move in SQL Server 2008 Integration Services from VSA to VSTA for scripting doesn't just give us C# and a better IDE and Add Reference dialog. It has also made programmatic manipulation of the Script task easier and more supportable. This week I got some sample code from Evgeny Koblov, one of our SSIS testers recently hired from Russia. His English is remarkably good...and makes me ashamed that I'm still confused by the Cyrillic a... [More]

My Variable doesn't like my Object any more - FIXED!

THIS LIMITATION HAS BEEN FIXED AND REMOVED FOR SQL SERVER 2008 RTM. Object of any type can now be passed through package variables of type Object, and consumed within Script task code. No, wait. Maybe it's "My Object doesn't like my Variable." Anyway, we just had to remove one of the Integration Services package samples ("SmoTablesDBCC") for Katmai because of this issue that affects the Script task. There are many Types that you will no longer be able to pass into a Script task by way of a package Vari... [More]