Can SQL 2008 Business Intelligence Studio SSIS packages run in SQL 2005?

1
votes

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.

2
sql-server-2005sql-server-2008ssisbusiness-intelligence
What do you mean by 'against' - run in a 2005 environment, or use 2005 as a data source? - cdonner
Run in a 2005 environment (ie. with no 2008 installations required in production) - Richard Szalay

2 Answers

1
votes

Yes it is possible - I run 2008 developed dtsx packages all the time on our 2005 box.

1
votes

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