Are you getting an error on the "Return Code"?
I've used them in the past and got errors concerning the return code where
the message was "Process returned code 1, which does not match the specified
SuccessReturnCode of 0". If that's all it is, then just change the return
code in the task properties to 1.
If the bat file is on a network share that the account SQL Server is running
under doesn't have rights to, it will fail as well, but when you go in and
try running it manually under your account that does have rights it will
succeed.
Turn on logging in the "Package properties" and then you can take a look and
see what the error is by right clicking the package and going to "Package
Logs...".

-----Original Message-----
From: Pete Ade [mailto:[Email Address Removed]
Sent: Thursday, September 12, 2002 8:39 AM
To: LazyDBA.com Discussion
Subject: DTS Excute process task

Hi,
I have a simple dts package(save on sql server) that runs
a batch process(zippin files) and email the content of the
zipped file.

This process always run with no error the first time. But
when I run it again it always fails unless I go inside the
property of the 'Execute process task' task and basically
refresh the Win32process that am running.

I don't mind refreshing, but not manually. Is there a way
around this?

thanks.




_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com


---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page