Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Why doesn the Database Partitions task support the ODBC connection manager?

April 26, 2017connection database manager ODBC partitions support Task

0

Posted

Why doesn the Database Partitions task support the ODBC connection manager?

1 Answer

0

Posted

Unfortunately, the current incarnation of SSIS 2005 has incomplete connections support. ODBC is one of these connections. You can read more about the issue here: Sql Server Integration Service (SSIS) Execute SQL Task ODBC Result Set Bug/Workaround. The workaround doesn’t work because the connection returned by the manager is not of type OdbcConnection. We are working on possible solutions to be delivered in a future version.