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:
Starting in the February CTP (CTP6), SSIS can automatically update your connection strings for you.
Note, while SNAC10 is backwards compatible with SNAC9, there are some slight behavior differences .
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.
What's New in SQL Server Native Client 10.0
Updating an Application to SQL Server 2008 Native Client from SQL Server 2005 Native Client
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.