September 12, 2013 at 1:48 am
Is it possible to connect from a SSIS 2008R2 package to a SQL Server 2012 database? The SSIS 2008 R2 packages resides on a separate ETL server (SQL Server 2008R2). Do we have to install a SQL Server 2012 provider at the etl server?
September 12, 2013 at 2:33 am
It is no problem 🙂 You do not have to install any new drivers or providers to connect to SQL Server 2012. You can use the SQL Server Native client 10.0 and you are able to connect and retrieve data and insert it into a SQL Server 2008R2 database.
September 12, 2013 at 3:01 am
tommy.tooten (9/12/2013)
It is no problem 🙂 You do not have to install any new drivers or providers to connect to SQL Server 2012. You can use the SQL Server Native client 10.0 and you are able to connect and retrieve data and insert it into a SQL Server 2008R2 database.
+1
You should have no issues at all.
I just did the same thing today and I even forgot I was using a SQL Server 2012 database.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 12, 2013 at 5:50 am
tommy.tooten (9/12/2013)
It is no problem 🙂 You do not have to install any new drivers or providers to connect to SQL Server 2012. You can use the SQL Server Native client 10.0 and you are able to connect and retrieve data and insert it into a SQL Server 2008R2 database.
Does SQL Server Native Client 11.0 (2012) offer better performance or other improvements compared to 10.0?
September 12, 2013 at 7:44 am
You can find all the improvements over here: http://technet.microsoft.com/en-us/library/ms131456.aspx
I assume the performance is not significantly improved with the new provider. You would have more improvements in the SQL Server engine I think.
As far as I read, you will also be able to connect to SQL Server 2014 with the 10.0 provider.
September 12, 2013 at 7:59 am
tommy.tooten (9/12/2013)
Thank you.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply