March 4, 2005 at 8:05 am
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.
Any ideas about this error??
Thanks in advance.
March 7, 2005 at 8:00 am
This was removed by the editor as SPAM
March 8, 2005 at 2:53 am
If you're only getting an error when the task run from a schedule, then it's probably a permissions thing - when you kick off the task manually it runs with whatever credentials you have given enterprise manager at logon; when you run from a schedule then you will run with the sqlserveragent's credentials for operations which don't run under a connection (I think).
Of course I could be completely wrong...
hth
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply