SQL Package Active X Task (Stop Execution from within VBscript)
Posted on 2007-09-28
I have a SQL 2000 DTS package.
In side the package I have an Active X Task (VBScript).
It looks to see if a file exists.
If Yes Main = DTSTaskExecResult_Success
***** want to stop procedure but return success to scheduled job.
In ohter words I have a package the is scheduled to run every day. Some days we don't receive a file, so I don't want an error or failure, just to stop the pacage from running and exit successfully.
Is this possible?