August 28, 2014 at 7:21 am
Hi there - I have recently developed a SSIS package to extract information from a database.
I developed the package in SQL Data Tool Visual Studio 2010.
I would like to run this package on two SQL instances, 2005 and 2008r2. Is it possible to run SSIS packages on older versions of SQL?
Thanks!
--------------------------------------------
Laughing in the face of contention...
August 28, 2014 at 7:57 am
I'm not aware of a way for SSIS packages created for SQL Server 2012.
I have used this utility before for conversion of 2008R2 packages to 2005 but doesn't support 2012
August 28, 2014 at 8:00 am
arrjay (8/28/2014)
Hi there - I have recently developed a SSIS package to extract information from a database.I developed the package in SQL Data Tool Visual Studio 2010.
I would like to run this package on two SQL instances, 2005 and 2008r2. Is it possible to run SSIS packages on older versions of SQL?
Thanks!
If you developed the package in SSDT 2010, you'll need SSIS 2012.
The data sources themselves may be of a lower version, but the SSIS engine needs to be 2012.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 28, 2014 at 10:10 am
Thanks for the response guys!
--------------------------------------------
Laughing in the face of contention...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply