Richard Szalay
Reputation: 84734
Can SQL 2008 Business Intelligence Studio SSIS packages run in SQL 2005?
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.
Upvotes: 1
Views: 1312
Answers (2)
rfonn
Reputation: 2221
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
Upvotes: 1
ajdams
Reputation: 2314
Yes it is possible - I run 2008 developed dtsx packages all the time on our 2005 box.
Upvotes: 1
Related Questions
- Can I use SQL Server Management Studio 2005 for 2008 DB?
- Sql server Integration Services 2008-2005 compatibility
- Can we create a SSIS package with BIDS 2008 R2 that can be installed on SQL server 2005
- SSIS package written in 2008 run on 2005
- Execute SSIS package on sql server 2005
- Can I run SSIS packages with SQL Server Express or Web or Workgroup editions?
- Can a SSIS package created with VS.net 2008 access a SQL Server 2005 database?
- Can I use SQL Server 2008 management studio with SQL Server 2005?
- SSIS in sql server 2005
- SSIS 2008 on SQL Server 2005?