DTS to Import Multiple Files

[dougcoulter]

I am looking to use DTS to import several TAB delimited files every night, whose filenames are not the same from day to day (they are date stamped). Some days there may be no files and others there may be several. My first question is can I handle this with DTS? If so, can anyone point me in the right direction?

My second question has to do with the format of the TAB delimited files. Here is an example:

1
13SEPT01 SQ 96-WELL
Well Sample Name Dye Set Mobility File
A1 10913000 E DT3100v1.mob
B1 10913001 E DT3100v2.mob
C1 10913002 F DT3100v5.mob

My table fields need to be Date, Well, SampleName, DyeSet and MobilityFile. Of the first three rows, I only need the date, and then I can easily transform the remaining fields according to the columns. I am just not sure how to handle the location of the date in this file with DTS. Do I have to use VBScript? If so, that is all right - but I am not sure how to go about it.

Any suggestions would be greatly appreciated!

 

[dougcoulter]

I have decided to develop a VB solution, but I am still interested if my problem could be solved with DTS. Has anyone used DTS in this manner? I found some assistance on the DTS How To from

http://wwww.swynk.com.

 

[tlbroadbent]

Check this link.

DTS: How can I change the filename for a text file connection?

http://www.sqldts.com/main.asp?nav=1,6,200,0

FYI: Questions similar to this have been answered a few times in this forum. The advanced search facility is very useful. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.