The SQL Native Client (SNAC) provider was renamed from SQLNCLI to SQLNCLI10 in 2008. The means that connection strings that used the Yukon provider (SNAC9) won't work if you only have the Katmai provider (SNAC10) installed.
This will affect most SSIS users, as we use SNAC as the default connection manager for a lot of things. To resolve this issue, you have two options:
- Install SNAC9 side by side with SNAC10. The redist can be found on the 2005 installation CD.
- Change the "Provider" portion of the connection string from "SQLNCLI.1" to "SQLNCLI10.1"
Starting in the February CTP (CTP6), SSIS can automatically update your connection strings for you.
Note, while SNAC10 is backwards compatible with SNAC9, http://msdn2.microsoft.com/en-us/library/bb964722(SQL.100).aspx .
New SSIS packages in Katmai will default to use SNAC10, but you can always switch the provider to SNAC9 if you have it installed on the machine.
http://msdn2.microsoft.com/en-us/library/cc280510(SQL.100).aspx
http://msdn2.microsoft.com/en-us/library/bb964722(SQL.100).aspx
