Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Deploying SQL Server 2012 SSIS packages in SQL Server 2008 R2 Expand / Collapse
Author
Message
Posted Tuesday, July 9, 2013 2:29 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, June 9, 2014 12:27 AM
Points: 184, Visits: 3,815
We had developed SSIS packages in SQL Server 2012 environment. But due to some unavoidable reason we need to deploy these packages in SQL Server 2008 R2 environment. Does SQL Server supports forward compatibility for SSIS packages?

---------------------------------------------------
Thanks,
Satheesh.
Post #1471849
Posted Tuesday, July 9, 2013 2:49 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 11:20 PM
Points: 13,252, Visits: 10,133
Satheesh E.P. (7/9/2013)
We had developed SSIS packages in SQL Server 2012 environment. But due to some unavoidable reason we need to deploy these packages in SQL Server 2008 R2 environment. Does SQL Server supports forward compatibility for SSIS packages?


No.

Interoperability and Coexistence (Integration Services)

There might be 3rd party software available that does a downgrade though.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1471860
Posted Tuesday, July 9, 2013 2:54 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, June 9, 2014 12:27 AM
Points: 184, Visits: 3,815
Thanks for the update Keon.

Do you have any suggestions for the 3rd party tool?


---------------------------------------------------
Thanks,
Satheesh.
Post #1471864
Posted Tuesday, July 9, 2013 2:58 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 11:20 PM
Points: 13,252, Visits: 10,133
Satheesh E.P. (7/9/2013)
Thanks for the update Keon.

Do you have any suggestions for the 3rd party tool?


No sorry. There is a tool on codeplex, SSISDowngrade, but SSIS 2012 support has not yet been added.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1471868
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse