Is it possible to run an SSIS package created by SQL 2008 Business Intelligence Studio in a SQL 2005 environment? I'd rather not have to install SQL 2005 / VS 2005 in my development environment.
+1
A:
Yes it is possible - I run 2008 developed dtsx packages all the time on our 2005 box.
ajdams
2010-01-18 14:06:14
Will this include Script Tasks written in C# (which, as I understand it, was not supported in BIS 2005)?
Richard Szalay
2010-01-18 14:10:11
No it will not, those you will have to convert to VB OR call the executables using the component (I forget the exact name for it but it can be done).
ajdams
2010-01-18 18:56:21
+1
A:
SQL Server 2008 uses a different scripting environment called VSTA(Visual Studio Tools for Applications) whereas Sql Server 2005 uses VSA(Visual Studio for Applications). This talks a little more about VSTA here: VSTA explanation
rfonn
2010-01-18 18:53:43