Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
ssis 2005 to ssis 2012

Answered ssis 2005 to ssis 2012

  • Monday, September 24, 2012 7:49 PM
     
     
    Sign In to Vote
    0

    hi,

    i want to convert ssis package from 2005 to 2012,how to do that?

    any steps i need to follow,i dont know how to migrate?
     

All Replies

  • Monday, September 24, 2012 8:14 PM
    Moderator
     
     
    Sign In to Vote
    0

    Upgrade to SSIS 2008 1st, then to 2012 from there.

    How to upgrade is described here: http://www.bidn.com/blogs/DevinKnight/ssis/2718/upgrading-packages-to-ssis-2012

    Arthur My Blog


     
  • Monday, September 24, 2012 9:29 PM
     
     
    Sign In to Vote
    0

    but this link doesnt show to upgrade to 2008 first,

    why cant i just upgrade from 2005 to 2012

     
  • Monday, September 24, 2012 10:27 PM
     
     
    Sign In to Vote
    0

    You should be able to upgrade from 2005 to 2012 as stated here. Follow the steps given in this link to upgrade 2005 to 2012.

    Guess Arthur Z. suggests upgrading to 2008 first and then 2012 cause thats a natural progression of packages in terms of technology and the possibility of running into issues would be lesser. But nothing should stop you from taking a leap from 2005 to 2012.

    http://btsbee.wordpress.com/

     
  • Tuesday, September 25, 2012 1:39 PM
    Moderator
     
     Answered
    Sign In to Vote
    0
    I do suggest upgrading to SSIS 2008 1st, and test, thank you for your comment btsbee by the way, I hastily omitted this part, yes, the reason is in SSIS 2012 there are no more ActiveX tasks in addition to what is in that article, and several other small items were improved in SSIS 2008, but if you cannot upgrade to SSIS 2008 then most ordinary SSIS 2005 upgrade just fine to SSIS 2012 straight, please let us know how did the upgrade go.

    Arthur My Blog