Re: Loop thru files and process each one

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

- will

"Darren Green" wrote:

> 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
>
>
>
.

Relevant Pages

  • Re: Loop thru files and process each one
    ... Looping, Importing and Archiving ... > write a DTS Package to loop through the files and process each one. ... > file name into the Stored Proc. ... > package, but I do not know how to loop through each one, execute my stored ...
    (microsoft.public.sqlserver.dts)
  • Loop thru files and process each one
    ... write a DTS Package to loop through the files and process each one. ... I will need to execute a stored procedure against each file - passing the ... file name into the Stored Proc. ...
    (microsoft.public.sqlserver.dts)
  • Re: Speed problem with mssql 2000 and ado
    ... >FIELD2 = ntext ... >which is executed one thousand times in a loop. ... Looping like that is a poor idea for an SQL server. ... You can use the Execute method of AdoConnection to get a select query directly ...
    (borland.public.delphi.database.ado)
  • Re: Unfinished Loop
    ... different table cells. ... It appears to only execute the first instead of ... looping. ... How can I get it to loop through? ...
    (comp.lang.javascript)
  • Re: looping in c language
    ... # a pattern of plume dispersion in an unstable atmosphere, in which the plume undergoes marked vertical oscillations as it is alternately affected by rising convective plumes and the subsiding motions between the plumes. ... Looping can also occur as the result of a skipped stitch. ... hackers "leap frog" or loop through several computer systems before finally going into the system they actually intend to attack. ... the recordings were made sequentially on a roll and later manually synched to picture. ...
    (comp.programming)