I am not able to see ODBC 64-bit drivers in the SSIS connection manager dropdown list? only 32-bit drivers are appearing in the Visual Studio 2017 SSIS project. Any solution to see a list of available DSN 64-bit ODBC drivers?
1 Answers
0
votes
I don't think you can see 64-bit ODBC sources using Visual Studio since it is a 32-bit application and ODBC 64-bit DSN only appears within 64-bit applications.
Workaround
Create two ODBC DSN (32-bit and 64-bit) having the same name. Then run the package in 64-bit mode then it will connect to the 64-bit DSN.
This workaround is mentioned in the ThoughtSpot ODBC Driver guide for SSIS.
