Post reply

how to Downgrade/Migrate SSIS2012 package to SSIS2008/R2

  • May 31, 2013 at 7:15 am

    #278430

    Team,

    I know I am asking very silly question, But We have put all our efforts to develop SSIS 2012 solution and now customer requirement changes and they wants to implement ETL in SQL2008R2.

    Is there anyway by which we can convert existing SQL 2012 packages to SQL 2008R2 so that we can save our efforts atleast up to 50%.

    Thanks,

    Nimesh

  • May 31, 2013 at 9:17 am

    #1620135

    Nimesh_Parikh (5/31/2013)

    Team,

    I know I am asking very silly question, But We have put all our efforts to develop SSIS 2012 solution and now customer requirement changes and they wants to implement ETL in SQL2008R2.

    Is there anyway by which we can convert existing SQL 2012 packages to SQL 2008R2 so that we can save our efforts atleast up to 50%.

    Thanks,

    Nimesh

    There is a utility which would help you downgrade from 2008 to 2005. But between 2008 and 2012, there was quite a big change in the DTSX file format which means that, as far as I know, there is no way of doing this.

    Having said that, there is no reason why the packages should not run on a separate 2012 server while the databases are on a 2008 db server.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply