Execute Process task – how to make exe fail task | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Execute Process task – how to make exe fail task

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.
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.
]]>