September 27, 2016 at 7:23 am
I have read that OLEDB connection managers SQL 2012 SSIS do not support multisubnetfailover=true properties and it you have to use ADO.net.
Can someone confirm that in SQL 2014 this is supported? I have created a package and put the property in Extended Properties and it hasnt errored, but i just want to clarify if i need to change all my connection managers or not??
September 27, 2016 at 7:38 am
It's an option for the version 11 and 13 ODBC driver
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
September 27, 2016 at 7:43 am
It seems to be working, i have failed it over a few times between different data centers using OLEDB with multisubnetfailover=true without issues.....
I think the article i read is bullsh1t
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy