Why doesn't the Database Partitions task support the ODBC connection manager?
Unfortunately, the current incarnation of SSIS 2005 has incomplete connections support. ODBC is one of these connections. 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.