DTS Execute Process Task Problems

[01310564]

Hi,

I have a DTS Package with about 20 or so steps. The third from last step is an Execute Process Task which tries to run a VB application of mine. When I run the task through Enterprise Manager on the server it works fine but when i scedule the job it just hangs. When i look at task manager my vb application is there but it's processing time just sit's on 0. I have also tried to run it through an active script like this.

Set oShell = CreateObject ("WSCript.shell")
oShell.run "C:\Program Files\Caudwell\test.exe",1,true

But this has the same effect.


Does anyone have any ideas?

By the way i using SQL 7 with the latest service pack.

Cheers,

Hugh

 

[ArtieChoke]

Oh, the joy of SQL Agent... NOT! ;-) At any rate, I've run into the same situation, where a VB program just won't run directly from the scheduler. Try creating a command file (.bat) that just runs the program. That's always done the trick for me. I've never been able to figure out what causes this situation, but the .bat file usually fixes it.

 

[01310564]

Thanks I'll give it a go.

Cheers,

Hugh