package won't stop on failure

#1

Using SS2000 SP3a. I have a step in a package where I check for the existence
of a file. If the file is not there, I want the package to stop but it
doesn't. I've set "fail package on first error in package properties. The
code in the step is this:
Function Main()
Set fso=createobject("scripting.filesystemobject")
If fso.fileexists("G:\Import\mission_weekly.txt") then
Main = DTSTaskExecResult_Success
Else
Main = DTSTaskExecResult_Failure
End If
Set fso = nothing
End Function

What am I doing wrong?
Thanks,
--
Dan D.

#2

I can't see anything wrong....i made some examples with ActiveX task and the
package stops.
Try, if it's possible in your package, using "On Success" Workflow

Francesco Anti

"Dan D." <DanD (AT) discussions (DOT) microsoft.com> wrote

Quote:

Using SS2000 SP3a. I have a step in a package where I check for the
existence
of a file. If the file is not there, I want the package to stop but it
doesn't. I've set "fail package on first error in package properties. The
code in the step is this:
Function Main()
Set fso=createobject("scripting.filesystemobject")
If fso.fileexists("G:\Import\mission_weekly.txt") then
Main = DTSTaskExecResult_Success
Else
Main = DTSTaskExecResult_Failure
End If
Set fso = nothing
End Function

What am I doing wrong?
Thanks,
--
Dan D.

#3

I already have a step after this one based on "On Success" and it always goes
to that step even when there is no file. This is the third step of about 20
steps in the process.

"Francesco Anti" wrote:

Quote:

I can't see anything wrong....i made some examples with ActiveX task and the
package stops.
Try, if it's possible in your package, using "On Success" Workflow

Francesco Anti

"Dan D." <DanD (AT) discussions (DOT) microsoft.com> wrote in message
news:7027DFE9-240D-4515-A67C-F231D9191939 (AT) microsoft (DOT) com...
Using SS2000 SP3a. I have a step in a package where I check for the
existence
of a file. If the file is not there, I want the package to stop but it
doesn't. I've set "fail package on first error in package properties. The
code in the step is this:
Function Main()
Set fso=createobject("scripting.filesystemobject")
If fso.fileexists("G:\Import\mission_weekly.txt") then
Main = DTSTaskExecResult_Success
Else
Main = DTSTaskExecResult_Failure
End If
Set fso = nothing
End Function

What am I doing wrong?
Thanks,
--
Dan D.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

package won't stop on failure

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

package won't stop on failure - 01-27-2005 , 03:17 PM

Re: package won't stop on failure - 01-28-2005 , 03:09 AM

Re: package won't stop on failure - 01-28-2005 , 06:53 AM