I successfully use the TeraData ODBC driver via an ADO NET Source in SSIS to retrieve data from a TeraData DB. Start by creating an ODBC Data Source in Windows. Then reference the DSN in a new ADO NET connection within your SSIS package. Then you can reference the ADO NET connection in an ADO NET Data Source in a Data Flow Task.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato