When working with legacy SSIS packages in Visual Studio 2019, it’s common to rely on OLE DB connections using SQL Server Native Client 11 (SQLNCLI11). This driver, though deprecated, is still widely used and can be configured to work securely with Azure SQL and TLS 1.2, even over VPN connections. This article explains how to… Continue reading
Confirming SQL Native Client TLS 1.2 Compatibility for SSIS and Azure SQL
