Data Flow Sources - What should I pick for ODBC database?

• Loner

  SSC-Insane

  Points: 21279

  More actions

  April 2, 2008 at 8:08 am

  #122919

  I tried to do a Data Flow Task, the input is an ODBC database and I already created a DSN, I also put it in the connection manager.

  however when I went to data flow task, the data flow sources had the following - DataReader, Excel, Flat File, OLE DB, Raw File, XML.

  How can I get an ODBC database as the input source?

  Please help!

  Thanks

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  April 2, 2008 at 8:39 am

  #797289

  Use a DataReader source.