Is it possible to deploy SSIS 2012 package on SQL Server 2008

sql-server-2008 visual-studio-2010 ssis ssis-2012
Thea picture Thea · May 8, 2012 · Viewed 26.2k times · Source

I have a package that is developed in SSIS 2012 using Visual Studio 2010.

  • Is it possible to deploy/attach this package on SQL Server 2008

  • If it is possible, does the licence of the sql server matter

Answer

Diego picture Diego · May 8, 2012

no, you cant. SSIS package are not backwards compatible.

Also it doesn't make much sense if you think about it. If it was the other way around, "maybe" it could be done because 2012 would somehow be aware of 2008 structure, but 2008 engine isn't aware of 2012 package structure.

Related questions

How to find server name of SQL Server Management Studio

I installed Microsoft SQL Server 2008. When I start SQL Server Management Studio (SSMS), I get the Connect to Server login window with a blank textbox for Server name. I have tried a lot of names, but I couldn't solve it. …

Read More
How to install SQL Server Management Studio 2008 component only

Below is a list of the SQL components that I installed in the Visual Studio 2010 Professional setup. Sadly, while trying to work I could not find SQL Server Management Studio 2008. Is there a way to download SQL Server Management Studio 2008 …

Read More
Visual studio 2010 and Sql Server

Do visual studio 2010 include already Sql Server instance, or I need to install Sql Server developer edition to develop an application that need a Sql Server db. If it installs a Sql Server express edition, it this enough or it's …

Read More