SQL 2000 DTS Job Execute Process Task hangs...

[kraxmo]

I am trying to execute a VB 6 executable program (DTSXSMod.exe) from a SQL 2000 DTS job Execute Process Task. The program runs perfectly in a DOS window, it runs perfectly when I manually execute the DTS
Execute Process Task step within the package, and it runs perfectly when I manually execute the DTS package. Each time when I run the program/step/package, my execution times are consistently under 2 seconds.

PROBLEM: When I try to the packaged using the scheduler, the job runs forever. I cancel the job, check the Windows Task Manager Processes, and the DTSXSMod program is still running.

How do I correct this situation?

Note: program DTSXSMod does not return any values if it executes successfully. When I execute it in a DOS window, it pauses briefly and then displays the DOS prompt. Jim Kraxberger
Developing Access solutions since 1995

 

[stoolpigeon]

You have a vb 6.0 program that runs from the command line?

 

[kraxmo]

Yes, it is a form-less executable that receives various parameters and dynamically modifies the Source SQL Statement of a DTS Transform task. Jim Kraxberger
Developing Access solutions since 1995

 

[stoolpigeon]

Sounds like either it is a SQL Server issue or something in the code of your executable- not something that can be looked at from a vb perspective w/out knowledge of what is going on in the program. (But I'd keep poking around I do not have experience w/VB programs written that way.)