just a hunch - but isn't there an extended stored procedure that will unload
a dll? You can find out from task manager what is being called and unload it
before you run the task.

-----Original Message-----
From: Pete Ade [mailto:[Email Address Removed] Thursday, September 12, 2002 10: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