Hi,
I'm getting some funny error. I've developed a c# (console
application) code - .exe - and Using DTS (SQL 2000) Execute Process
Task to run the .exe.
I run the process every month. Now when I run the process, I get
following
error; "CreateProcessTask 'DTSTask_DTSCreateProcessTask_2': Process
returned code -532459699, which does not match the specified
SuccessReturnCode of 0.

But when I open the Exectue Process Task (task where I'm calling
c# .exe code) and go in property and give the Win32Process location
again (even I've not changed any code or any location) and Save the
package, it runs fine.

I've some C++ .exe code also in the DTS package and that code also
I'm calling with other Execute process task, but it runs fine.

I've tried following things. There is no credential issues. I set workflow
properties to "Execute on Main Package thread" But no success so far....
Any ideas about this error??

Thanks in advance.

As you mentioned, it is really frustrating when the package just stops
working for no reason. If that happens usually I recreate the package
and it just start working again as normal.

Cheers,
Yunus.