All content (copyright) respective authorsthandaz's code bookmark tagged with dtshttp://www.codaddict.com/thandaz/dtsthandaz's code bookmark tagged with dtsStop DTS Package Execution Conditionally Without FailureDim fso, file1
Dim pkg
SET pkg = DTSGlobalVariables.Parent

Set fso = CreateObject("Scripting.FileSystemObject")

IF (fso.FileExists("c:\abc.txt")) THEN
Msgbox "File exist. Continue"
pkg.Steps("DTSStep_DTSActiveScriptTask_2").DisableStep=False

Set fso= Nothing

ELSE
Msgbox "Stop"
pkg.Steps("DTSStep_DTSActiveScriptTask_2").DisableStep=True
END IF
set pkg=nothing
Main = DTSTaskExecResult_Successhttp://www.codaddict.com/thandaz/SQL ServerthandazMon, 04 Jan 2010 11:32:21 GMT