SQL Server Performance

Execute Process task - how to make exe fail task

Discussion in 'SQL Server DTS-Related Questions' started by Dave Wells, May 30, 2003.

  1. Dave Wells New Member

    I need to call an exe as part of a DTS package and have that exe be able to report success or failure to the DTS package.

    I'm sure this will no doubt be a simple matter but I can't find out how to do it.
  2. Dave Wells New Member

    It was indeed very simple. I just needed to set the return value in the property of the task and make sure the exe returns that for success.

Share This Page