Vinh Ton
Reputation: 107
Why does ODBC Connections not show up as an option for Execute SQL Task in Visual Studio's SSIS Connection Manager?
I have multiple connections under the Connection Manager but when I selection Connection I am only able to see the OLE DB Connection and not the 2 other ODBC connections.
Some background in case that is relevant I'm using Visual Studios 2019. The OLE DB connects to a MS SQL server. The other ODBC connections connect to PostgreSql servers. The PostgreSql drivers were made available to Visual Studios through the ODBC Data Source Administrator's System DSN.
Upvotes: 0
Views: 14
Answers (0)
Related Questions
- I am not able to see ODBC 64-bit drivers in SSIS connection manager drop down list?
- SSIS Error: Disconnected recordsets are not available from ODBC connections
- SSIS can't connect to DB2 running in SQL Server: ERROR [IM004] [Microsoft] [ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
- SSIS Connection Manager - Azure SQL Database intermittent failure
- Azure SSIS Package - Execute SQL Task
- How do I do an ODBC connection to ORACLE from SSIS/ Visual studio?
- SSIS - Transfer SQL Server Objects Task - Problems with SMO Connection Manager
- SSIS Deploy Connection Properties for ODBC
- connection string for classic asp application using odbc 11 for sql server
- SSIS package fails in sql server agent, but not in visual studio. ODBC Connection