Saturday, February 25, 2012

How to migrate SSIS packages from SQL Server 2005 to 2008

In SQL Server 2005 by default SQL Native Client will be installed

1. First Make sure to install SQL Native Client on SQL Server 2008.
2. Using (BI) SSIS Package Upgrade Wizard on SQL Server 2008 to upgrade the SSIS packages.

SQL Server Native client 10.0 will be automatically isntalled when you install sql server.
Once you upgrade the SSIS packages you can easily change to SQL Server Native client 10.0