Read from Text file

• Ramesh Saive

  SSC-Insane

  Points: 24275

  More actions

  May 8, 2009 at 5:59 am

  #990993

  Jeff Moden (5/4/2009)

  ---

  Ramesh (5/4/2009)

  ---

  I would go with SSIS and the following link should get to started

  http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx

  Not a bad recommendation... I just do it all from T-SQL. I hope to never learn how to even spell "SSIS".

  C'mon Jeff:rolleyes:, "SSIS" is indeed a great tool for ETL. I really started to like it very much because of its ease of use, graphical tools and limited no. of functions/tasks/objects good enough to do the most common activities. It just took me 7 days to learn the basics of SSIS.

  And, I hope that you would also like it once you get started with it:-).

  --Ramesh
  

  ---