Post reply

SSIS Packages run on older versions of SQL

  • August 28, 2014 at 7:21 am

    #298871

    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

    #1741651

    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

    http://ssisdowngrade.codeplex.com/

  • August 28, 2014 at 8:00 am

    #1741653

    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

    #1741691

    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