dts & importing multiple txt files

• Herbie Bauce

  Grasshopper

  Points: 19

  More actions

  September 10, 2004 at 1:57 am

  #59976

  Hi

  absolute novice at this but I have been tasked with

  the following:

  Given a dts "import text file" task and a bunch of files scattered in different directories, how do I get to them

  and process each one from the pkg?

  Also, the filename dictates which DB to select - how do I tell DTS which DB to switch to?

  All this most probably, has been covered ad naseam -

  any guidance would be greatly appreciated

  regards

• September 13, 2004 at 8:00 am

  This was removed by the editor as SPAM

• Larry Stein

  Default port

  Points: 1447

  More actions

  September 13, 2004 at 8:19 am

  #522758

  Not sure I understand the first question - "how do I get to them?"  If the locations are fixed and you simply want to cycle through all files (perhaps with a particular name pattern) in the appropriate directories, that is (fairly) easily done in ActiveX scripts.  There is a good example of looping through objects at sqldts.com: http://www.sqldts.com/Default.aspx?246

  Changing the DB name is the same thing - use ActiveX to parse out the desire connection name and then modify the DTS connection object.

  Good luck,

  Larry

  Larry

• Herbie Bauce

  Grasshopper

  Points: 19

  More actions

  September 13, 2004 at 9:03 am

  #522775

  Hello Larry,  et al

  the major stumbling block is basically that I know zip

  about activeX and therefore am a bit reluctant about using it.

  (Although, going through BOL, I see that many of the advanced topics

   have examples using it - so I reckon I'd better look at it more seriously)

  Yes, the problem is a common one, and yes, I did manage to arrive

  at a non-activeX 'solution' of sorts: using the "for.." cmd in the humble MSDOS batch file,I eventually managed to get my files into a table!

  Thanx for the advice & the URL,will definitely visit   

  regards

  hb

• Sam Adekeye-153233

  SSC Enthusiast

  Points: 102

  More actions

  September 17, 2004 at 6:32 am

  #523481

  Hi Larry,

  I checked the url but I seem to have a problem with the package because it seems only one file(they are CSV files with the last few digits as dates) is loaded several times into the database. I must be doing something wrong.

  Thanks for your anticipated help.

  Sam