Re: Loop thru files and process each one
- From: "Darren Green" <darren.green@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 23 Aug 2005 10:00:16 +0100
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A1AA282D-BA62-4A70-B2AF-1956292DBB4D@xxxxxxxxxxxxxxxx
> 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
.
- Follow-Ups:
- References:
- Loop thru files and process each one
- From: dw
- Loop thru files and process each one
- Prev by Date: Loop thru files and process each one
- Next by Date: Re: Execute DTS Package Through T-SQL
- Previous by thread: Loop thru files and process each one
- Next by thread: Re: Loop thru files and process each one
- Index(es):
Relevant Pages
|
