I have four files which I need to pick up and process. I have written the active x script to find the files and the execute sql to truncate the table and the connection and the transformation, but I am having trouble figuring out how to make them work together. I want to loop through the files and execute against each one, but it doesn't run the other tasks until after the whole script has completed. I need it to loop, execute, then return. I have it checking the files to see if they are empty so it is only processing the good ones, but then I rename the file to what the connection is looking for and it processes. But, I can't get it to process for each file. I tried to set up 4 different executions, but then there were errors on the ones that were empty. I am pulling my hair out and this should have been done last week. Please help!

Thanks.

Not sure I understand what you are doing but is it anything like this

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

If not then maybe you can explain a bit more about what you need

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"dbases" <dbases (AT) aol (DOT) com> wrote

and the connection and the transformation, but I am having trouble figuring
out how to make them work together. I want to loop through the files and
execute against each one, but it doesn't run the other tasks until after the
whole script has completed. I need it to loop, execute, then return. I
have it checking the files to see if they are empty so it is only processing
the good ones, but then I rename the file to what the connection is looking
for and it processes. But, I can't get it to process for each file. I
tried to set up 4 different executions, but then there were errors on the
ones that were empty. I am pulling my hair out and this should have been
done last week. Please help!!