Importing multiple text files

• ahmad-326642

  Grasshopper

  Points: 15

  More actions

  July 25, 2008 at 3:52 am

  #70476

  Hi

  I am fairly new to Sql server. I have a directory where i have all these text files

  D20080710.txt

  D20080711.txt

  D20080712.txt

  all these files needs to be imported into sql server . I normally do it either individually or i merge them using copy command in DOS.

  But I am trying to create a DTS package which loads all these text files automatically. But also insert the filename (D20080710.txt) to table.

  So that next time when DTS package runs , it checks if the file is already not loaded, based on the filename and if it does not exist it loads the

  file and update the table.

  I will appreciate if any one could help me with this task

  Thanks

• Matte-382450

  SSC Veteran

  Points: 211

  More actions

  August 1, 2008 at 5:03 am

  #851757

  Hi,

  still need help on this one ?

  Matte

• boisseau.xavier

  Grasshopper

  Points: 16

  More actions

  May 26, 2011 at 11:03 am

  #1330520

  Hello,

  Have you found a solution yet? I have a similar problem

• fox_0000_fox

  Grasshopper

  Points: 17

  More actions

  September 30, 2011 at 11:21 am

  #1388945

  Hi There

  I have the same issue any solution guys

  Thanks