Multiple CSV import using DTS

[zabrucewayne]

Can anyone tell me how to automate the process of importing multiple CSV files into a database?

It is easy to do it one at a time, but this will be extremely time consuming as I have a few hundred files to import.

Thanks.

 

[tlbroadbent]

Check the following links which explain how to import multiple files from a directory.

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

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

This article explains how to change the file name in a DTS connection.

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

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.