June 15, 2015 at 7:54 am
Since OLEDB is deprecated and because MultiSubnetFailover is not supported in OLEDB anyway, I have come full circle back to ODBC and must now create ODBC connections for ETL. (ADO.NET is too slow.)
Does anyone know of an automagical way to package up and deploy DSN's referenced by ODBC connection managers in SSIS?
"Beliefs" get in the way of learning.
June 15, 2015 at 2:22 pm
Since OLEDB is deprecated and because MultiSubnetFailover is not supported in OLEDB anyway, I have come full circle back to ODBC and must now create ODBC connections for ETL. (ADO.NET is too slow.)
Does anyone know of an automagical way to package up and deploy DSN's referenced by ODBC connection managers in SSIS?
"Beliefs" get in the way of learning.
ODBC does support the multisubnetfailover keyword
SQL Server Native Client Support for High Availability, Disaster Recovery
Joie Andrew
"Since 1982"
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply