July 9, 2013 at 2:29 pm
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.
July 9, 2013 at 2:49 pm
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 9, 2013 at 2:54 pm
Thanks for the update Keon.
Do you have any suggestions for the 3rd party tool?
---------------------------------------------------
Thanks,
Satheesh.
July 9, 2013 at 2:58 pm
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[/url], but SSIS 2012 support has not yet been added.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply