CODEWITHSUNDEEP
sql-serverssis-2012sql-server-native-client
Nayak
Nayak

Reputation: 473

SQL Native client driver 10 vs 11

Has anyone experienced a difference between SQL driver SQLNCLI11.1 vs 10.1?

I inherited a complex SSIS package where I had to make minor changes (package loads data from 18 files to a SQL database).

The package works well with 10.1. But gives an error with Unicode to non-Unicode conversion with 11.1. I didn't want to change the mappings in the whole SSIS package for my change. So I'm planning to use 10.1 provider explicitly in the connection string.

Do any of you see any issue with this approach?

Upvotes: 0

Views: 3647

Answers (1)

user3200692
user3200692

Reputation: 87

Only the sql server native client 11 can connect to SQL Server 2016. SQL server native client 10.1 cannot connect to SQL Server 2016.

You can download sql server native client 11 here: https://www.microsoft.com/en-us/download/details.aspx?id=50402

Upvotes: 1

Related Questions