Monday, September 24, 2012 7:49 PM
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?
Monday, September 24, 2012 8:14 PMModerator
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
- Edited by ArthurZMVP, Moderator Monday, September 24, 2012 8:15 PM added on how to
Monday, September 24, 2012 9:29 PM
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
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.
Tuesday, September 25, 2012 1:39 PMModeratorI 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
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Monday, October 01, 2012 7:16 AM