Loading Flat files

• wala.be

  SSC Rookie

  Points: 29

  More actions

  March 21, 2008 at 3:30 am

  #183527

  How to load more than one flat files (different tables) into SQL server database at the same time?

  Is there anyway to do this by using wizard or script?

  Thanks,

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  March 21, 2008 at 6:33 am

  #792402

  Did you have a look at the FOR EACH LOOP container in SSIS ???

  It's pretty easy to use. For an example see here http://www.sqlis.com/55.aspx

  [font="Verdana"]Markus Bohse[/font]

• wala.be

  SSC Rookie

  Points: 29

  More actions

  March 28, 2008 at 3:16 am

  #795021

  Thanks for the clue.