SQL 2008 migration | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL 2008 migration

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?

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.

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |