1. anilksharma99 New Member

   guys, 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?
   

   anilksharma99, Feb 13, 2011

   #2
2. satya Moderator

   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.
   

   satya, Feb 14, 2011

   #3

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in