>Hello all,
> I'm putting together a DTS package in SQL Server. The first component is a VFP exe. If this component fails, I want the package to stop executing, however, I can't seem to return a fail to it at all. In the VFP code, I've tried
>
>RETURN .F.
>RETURN 0x1004 && DTS documentation says this will make it fail
>RETRUN 1 && Testing in VBscript shows that this makes it fail
>
>all without success. Any thoughts? Thanks,
>John

Check out Message#496824 (http://www.levelextreme.com/wconnect/wc.dll?UniversalThread~?2,15,496824). The 99 value in the TerminateProcess call is the return code. If you substitute 0x1004, you might get what you need.

HTH.