Data Migration with SSIS and ODBC Driver for MongoDB
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 MongoDB 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 2.x version of ODBC 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 2.x version of ODBC behavior in the DSN settings: open the Advanced Settings tab and select Ver 2.x from the ODBC Behavior dropdown.