Parameters/Return Code in Execute process task +VB

[Sweenster]

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 much appreciated.

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

 

[Sweenster]

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.