re: Scripts and assembly caching in 2005

lianaent — Tue, 14 Jul 2009 16:37:15 GMT

I wrote some packages in BIDS 2008, but our company decided to go with SQL 2005 for some reason. In trying to write scripts (tasks or components) in SSIS 2005 I've found that I can't. I get a VSA error, and I'm assuming it's because I have VSTA, not VSA. But VSA is obsolete and I can't find anywhere to download it from. (I've tried all the SQL SP3 updates and hotfixes and regsvr32's etc., but no VSA - no dice.)

I've Googled and MSDN'd and can't find any help on this. HELP!

Please respond to lwakeman@tmghealth.com as this is an urgent business matter.

Thanks!

Larry

re: Scripts and assembly caching in 2005

mmasson — Tue, 14 Jul 2009 17:32:58 GMT

Hi Larry,

Unfortunately there's no automatic downgrade for packages/scripts. You'll need to cut and paste your script code from the 2008 designer to your 2005 package (or save the code file out, and reload it in the VSA designer). You might have to make some minor changes to the script as well, as some of the assembly references changed.

~Matt