SQL 2008 migration | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
SQL 2008 migrationguys, what is the best way to upgrade about a thousand SSIS packages from SQL2005 to SQL2008? Doing one by one looks tedious.
Also, in what cases the upgrade wizard (after BIDS launches it) might fail to upgrade?
As of now I will vouch and insist to use SSIS Upgrade wizard – http://msdn.microsoft.com/en-us/library/cc280547.aspx which helps to accomplish the tasks.
Coming to the scenario where it may fail, then you may take help of upgrade advisor tool – http://msdn.microsoft.com/en-us/library/cc280546.aspx that can get you full report of warnings & errors.