ADO.Net Source in ssis 2005

• scuby.me

  Mr or Mrs. 500

  Points: 587

  More actions

  July 16, 2014 at 6:23 pm

  #288679

  I dont see ado.net under Data flow sources in ssis 2005. How do i bring this source?

  Help

• Maninder Kumar

  SSChasing Mays

  Points: 606

  More actions

  July 17, 2014 at 12:09 am

  #1730114

  In BIDS,

  1. Go to Tools->Choose Toolbox Items

  2. Go to tab 'SSIS Data Flow Items'

  3. Verify whether 'ADO Net Source' checkbox has been checked.

  Cheers!

  Maninder

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  July 17, 2014 at 1:12 am

  #1730131

  scuby.me (7/16/2014)

  ---

  I dont see ado.net under Data flow sources in ssis 2005. How do i bring this source?

  Help

  I believe in SSIS 2005 it is called Datareader.

  http://msdn.microsoft.com/en-us/library/ms137897(v=sql.90).aspx

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP