Hello...

A customer will be sending me several files each day and I want to try and
write a DTS Package to loop through the files and process each one.

I have figured out how to read through the contents of a folder/directory
and look at each file, but how do I get to the next step and process each
file?

I will need to execute a stored procedure against each file - passing the
file name into the Stored Proc. I can do this for a single file in my DTS
package, but I do not know how to loop through each one, execute my stored
proc task and then exit.

If anyone can help or pass along an article or link, I would appreciate it.

Thanks
- will

This shows looping over files and doing stuff with each one-

Looping, Importing and Archiving
(http://www.sqldts.com/default.aspx?246)


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"dw" <dw (AT) discussions (DOT) microsoft.com> wrote

Thanks for the link. This looks like it will do what I want.

- will

"Darren Green" wrote: