DTS package to import multiple files

[sonname]

Hi
I need to create a DTS package that will check a folder to see if there are files present in a specific folder, loop through the folder and import the multiple files in the folder into a table. After each successfull import of a file into the sql server table, move the file to another folder,continue with the next file etc.
Thanks in advance

 

[tlbroadbent]

Check the SQLDTS article, "How can I check if a file exists?" at

http://www.sqldts.com/main.asp?nav=1,6,211,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.