Importing data from many text files

[TomBarrand]

I want to read data from a number of text files and put the data into a table. The problem is that there can be any number of text files, it could be 2 it could be 50. I have looked at using a DTS and BCP, etc, but it appears that you have to point it to a specific file. There will be different files names. Any ideas?

Thanks,

Tom

 

[tlbroadbent]

Check these links.

Import all files in a directory (Multi Step)

http://www.swynk.com/friends/green/dtsdirloopstep.asp

Import all files in a directory (Multi Pkg)

http://www.swynk.com/friends/green/dtsdirlooppkg.asp

Terry L. Broadbent
Life would be easier if I had the source code. -Anonymous