How to launch a process synchronously in my DTS

#1

I am calling a WINZIP process to extract a zipped file using the code below
:

Set oShell = CreateObject("WScript.Shell")
strCommand = "WZUNZIP.EXE" & " -e -o- " &
DTSGlobalVariables("gLocalImportFolder").Value & "\" & file & " " &
strTempUnZipFolder
oShell.Run strCommand

The problem is that I am calling this process several times by iterating
through a collection of zipped files and because the process is called
asynchronously inside the iteration when the process is called whilst the
unzipping process is not finished the control gose to the next commad which
is moving the file to another folder and it is causing me a problem.

Is there a workaround for this?

Thanks

#2

Run Method
(http://msdn.microsoft.com/library/de...l/wsmthrun.asp)

Look at the bWaitOnReturn parameter.

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

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

Quote:

I am calling a WINZIP process to extract a zipped file using the code below
:

Set oShell = CreateObject("WScript.Shell")
strCommand = "WZUNZIP.EXE" & " -e -o- " &
DTSGlobalVariables("gLocalImportFolder").Value & "\" & file & " " &
strTempUnZipFolder
oShell.Run strCommand

The problem is that I am calling this process several times by iterating
through a collection of zipped files and because the process is called
asynchronously inside the iteration when the process is called whilst the
unzipping process is not finished the control gose to the next commad
which is moving the file to another folder and it is causing me a problem.

Is there a workaround for this?

Thanks

#3

Thanks Darren

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote

Quote:

Run Method
(http://msdn.microsoft.com/library/de...l/wsmthrun.asp)

Look at the bWaitOnReturn parameter.

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

"J-T" <J-T (AT) nospam (DOT) com> wrote in message
news:Ovb5TQWkFHA.3960 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
I am calling a WINZIP process to extract a zipped file using the code
below :

Set oShell = CreateObject("WScript.Shell")
strCommand = "WZUNZIP.EXE" & " -e -o- " &
DTSGlobalVariables("gLocalImportFolder").Value & "\" & file & " " &
strTempUnZipFolder
oShell.Run strCommand

The problem is that I am calling this process several times by iterating
through a collection of zipped files and because the process is called
asynchronously inside the iteration when the process is called whilst the
unzipping process is not finished the control gose to the next commad
which is moving the file to another folder and it is causing me a
problem.

Is there a workaround for this?

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How to launch a process synchronously in my DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

How to launch a process synchronously in my DTS - 07-25-2005 , 04:58 PM

Re: How to launch a process synchronously in my DTS - 07-26-2005 , 02:33 AM

Re: How to launch a process synchronously in my DTS - 07-26-2005 , 11:23 AM