December 22, 2005 at 3:20 am
If you don't want your job to report a failure then you will need to remove the
Main = DTSTaskExecResult_Failure
You might want to create an empty (null) file and have the DTS package "process" that if the test.txt does not exist.
-------------------------------------------------------------------------
Normal chaos will be resumed as soon as possible. :crazy:
December 22, 2005 at 8:05 am
I thought of a few work arounds, I could make an extra pkg just for the file check to on fail quit with success but didn't want to packages for every package or even extra steps in the job. This is seeming to work now with adding a workflow property to prevent the dts package step from failing and the job has'nt reported a failure either:
Function Main()
sFile = "C:\any.txt"
Set oFSO = CreateObject ("Scripting.FileSystemObject")
If oFSO.FileExists (sFile) Then
Main = DTSStepScriptResult_ExecuteTask
Else
Main = DTSStepScriptResult_DontExecuteTask
End If
End Function
Since this step is the first in the package It can't fail if the file is not there, there is possibly a Main = "something to say job success or job failure" results statement when using ActiveX as a job step that would give the output needed.
Thanks.
Moderator, as a newbie how can this thread be closed?
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply