question

paws27284 avatar image
paws27284 asked

Can i install SQLNCLI11.1 on a SQL 2008 r2 server?

I have a SQL 2008 r2 database (DB1). I use SSIS on DB1 to connect to another 2008 r2 database (DB2). I pull data from DB2 to DB1. DB2 is being upgraded to SQL 2012. My SSIS packages are receiving errors that it cannot access DB2 with Provider=SQLNCLI10.1. Ok that makes sense. Can I install SQLNCLI11.1 on DB1 for my SSIS packages?

sql server 2008 r2sqlncli11.1 on 2008 r2
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.