Data Migration with SSIS and ODBC Driver for Azure Synapse Analytics
SQL Server Integration Services (SSIS) is a component of SQL Server that is designed to perform various data migration tasks. When using Devart ODBC Driver for AzureSynapseAnalytics as a translation layer between the data source and SSIS, the driver and SSIS communicate via Microsoft ODBC version 3.x.
Note that when you extract data from an ODBC data source using the SQLExecDirect function, an issue may occur: SSIS expects the ODBC 2.x behavior, while the ODBC driver continues to fetch data from a data source via ODBC version 3.x. To prevent any issues when using SQLExecDirect, you should force the ODBC 2.x behavior in the DSN settings: open the Advanced Settings tab and select Ver 2.x from the ODBC Behavior dropdown.