July 7, 2011 at 10:08 am
Hi,
What is the best practice for migrate SSIS 2005 packages to SSIS 2008 packages.
We have around 700+ packages to migrate. some of them saved in MSDB and some of them saved in file system. Is there any way to migrate all the packages at a time. THANKS!
July 7, 2011 at 10:53 am
BIDS will do the upgrade (generally) but you need all of the packages in the file system, thats the only place they can be edited. As far as doing all of them at once.. Not sure, BIDS will upgrade packages, you could build a project file with the packages and open it in BIDS and it should prompt you. but I wouldn't do all 700, I'd break it down to a manageable number 50-100. I think you might have some issues with connection strings. Not sure how good the upgrade is now, but when I went from 2005 to 2008 RTM the connection strings were referencing the 2005 version of the native client and they didn't get upgraded. The change was easy but I had to do it by hand.
CEWII
July 7, 2011 at 11:00 am
Similar thoughts on this as Elliot. I would break down the upgrade into smaller chunks. Allow for enough time to test the packages after the upgrade.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 11, 2011 at 3:19 am
Elliott Whitlow (7/7/2011)
BIDS will do the upgrade (generally) but you need all of the packages in the file system, thats the only place they can be edited. As far as doing all of them at once.. Not sure, BIDS will upgrade packages, you could build a project file with the packages and open it in BIDS and it should prompt you. but I wouldn't do all 700, I'd break it down to a manageable number 50-100. I think you might have some issues with connection strings. Not sure how good the upgrade is now, but when I went from 2005 to 2008 RTM the connection strings were referencing the 2005 version of the native client and they didn't get upgraded. The change was easy but I had to do it by hand.CEWII
As far as I know, the native client is still an issue. So the config tables and config files should also be upgraded!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply