dbTalk Databases Forums  

Execute Process Task Help

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Execute Process Task Help in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
MJS
 
Posts: n/a

Default Execute Process Task Help - 10-18-2005 , 05:48 AM






Hi,
I am trying to work out how to pass parameters from an execute process task
to a vb .exe and then return a code so that the package knows if that step
worked.
Everything I have found so far is geared towards executing packages from
within VB and we want to execute a vb app from the DTS package.

Currently the DTS step says successful whether or not the .exe did its stuff.

Any help would be mush appreciated.

FYI the .exe builds a Cognos cube, checks for temp files and then copies
these files around the network.

Reply With Quote
  #2  
Old   
MJS
 
Posts: n/a

Default RE: Execute Process Task Help - 10-18-2005 , 10:24 AM






Passing parameters is sorted. Just need to work out how to get the .exe to
send a return code to the execute process task in the DTS package.

"MJS" wrote:

Quote:
Hi,
I am trying to work out how to pass parameters from an execute process task
to a vb .exe and then return a code so that the package knows if that step
worked.
Everything I have found so far is geared towards executing packages from
within VB and we want to execute a vb app from the DTS package.

Currently the DTS step says successful whether or not the .exe did its stuff.

Any help would be mush appreciated.

FYI the .exe builds a Cognos cube, checks for temp files and then copies
these files around the network.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.