In my dts I have a logic in activex task where if file
exists then sucess else is fail. I wanted to have an
outcome of DTS as sucess, becuase the DTS actually runs.
How do I do this. I try to have a laststep activex-sucess
but it is not working.

You really want things to fail ?

Personally I would just take differing actions based on the outcome of trying to retrieve the file

You could do something like this

if DTSGlobalVariables("PassOrFail").Value = "Pass" then
Main = DTSTaskExecResult_Success
Else
Main = DTSTaskExecResult_Failure
End If

Make sure you set the package properties to fail on first error





--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"anonymous22" <anonymous (AT) discussions (DOT) microsoft.com> wrote

If file with in 24 transfer the data if not don't transfer
the data. I have the activex when it is checking for 24
time frame and then on sucess it will tranfer the data if
not I still wanted to have a dts outcome as sucess.
What should I do in order to get it working right?