Hello,

I have a dts package (DTS1) that is fixed to process a text file with a
specific name and load it into my database.

I have several files that need to be loaded by this dts, so I was
wondering how I could do this.

I programmed a separate DTS that has an activex script that runs in a
loop: it gets a file, renames it and runs the dts package (DTS1).

I thought this would work but when I call this line that runs the DTS
package:

oPkg.LoadFromSQLServer
msDTSServer,msDTSUser,msDTSPwd,DTSSQLStgFlag_Defau lt,"","","",DTS1

It does not wait for (DTS1) it to finish before continuing with the
loop. So what ends up happening is DTS1 gets called again and again.
I need it to wait for DTS1 to finish before proceeding.

Does anyone know how to deal with this?

Thanks in advance.
Clem

also if anyone has any other ways to do this, it would be much
appreciated.

You want to loop and pick up files?

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

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


<clemlau (AT) yahoo (DOT) com> wrote

Allen Are you still following up with my ASP.NET and C# post?:-) or you gave
it up?

Thanks
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

I am a bit busy at the mo but can you ping me privately with all I need so I
can try to duplicate your problem?

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"J-T" <JT (AT) nospam (DOT) com> wrote

I sent the code to your email.

I so appreciate your help
Thanks a million
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote