The SSIS server error that started our research was: "The requested OLE DB provider SQLNCLI10.1 is not registered" ![]() That is, it never had SQL Server 2008 installed or an older OS. Our problem occured because the hosting db server never had the old SQL 2008 "SQLNCLI10" installed. We followed these suggestions to install SQLNCLI10 on our 2012 database server. The First Answer From Sqillman ( ) works! Kudos!įor us, the answer (above/below?) allows access to SQL Server 2000 databases from SQL Server 2012 Integration Services packages that are hosted on a SQL Server 2012 database server running on Windows Server 2012 OS.
0 Comments
Leave a Reply. |