Groups | Blog | Home
all groups > sql server dts > august 2006 >

sql server dts : ODBC Connection manager - SSIS


sqlboy2000
8/2/2006 11:41:58 AM
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?

Drutch
8/25/2006 9:08:02 AM
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.
[quoted text, click to view]
AddThis Social Bookmark Button