Hi,
I'm able to create a connection manager in ssis for an ODBC datasource.
However I don't see anyway to use it as a source or desitination in a data
flow task. Am I missing something obvious here?

Thanks in advance.

Go to your Data Flow tab and add a Data Flow Source from the Toolbox.
Right click on the new Data Flow Source and choose edit.
Choose the Connection Manager you've created as the connection Manager for
the Data Flow Source.
Works same way for a Data Flow Destination.
"sqlboy2000" wrote: