Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SSIS - how to select odbc data source

Status
Not open for further replies.

ddiamond

Programmer
Apr 22, 2005
918
0
0
US
In SSIS 2008, I was able to define an odbc connection manager. But when I go to the tool bar, I can't find an ODBC data flow source. The only data flow sources I see on the tool box are ADO NET, Excel, Flat File, OLE DB, Raw File, and XML. So how can I use my odbc connection manager?
 
ODBC should be used through ADO.Net. Choose an ADO.Net source, and it should let you pick your ODBC connection manager.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top