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?