Re: Main = DTSTaskExecResult_Failure does not raise an error

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks for your reply Allan. I had tried just using Main =
DTSTaskExecResult_Failure in a script on Friday, but I also had a Main =
DTSTaskExecResult_Success after it. I.e.,

Function Main()

Main = DTSTaskExecResult_Failure

Main = DTSTaskExecResult_Success

End Function

I am unclear on when an error is raised by DTSTaskExecResult_Failure in
a script, does this immediately raise the error and return to workflow
and other steps or is the remainder of the script executed? When I tried
just

Function Main()

Main = DTSTaskExecResult_Failure

End Function

The failure was returned and package execution was stopped. This is a
big step forward from Friday.


*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • Re: DTS pulling data from Oracle via Link server
    ... On my test PC, I created a linked server, write ... the following script, and then unplug the network cable. ... "Allan Mitchell" wrote: ...
    (microsoft.public.sqlserver.dts)
  • Re: Variable text file destination name
    ... Ooh Allan, I could kiss you!!! ... I've always been scared to death of ActiveX VB scripting ... >The script will go in the Active Script task. ... >> destination dynamically to Access or SQL databases I ...
    (microsoft.public.sqlserver.dts)
  • Re: Problem running a script on startup
    ... Microsoft MVP [Windows] ... "Allan Cady" wrote: ... | the correct command to run the script. ... | what can I do that will make the script run without logging on? ...
    (microsoft.public.win2000.registry)
  • Re: Problem running a script on startup
    ... Microsoft MVP [Windows] ... "Allan Cady" wrote: ... | the correct command to run the script. ... | what can I do that will make the script run without logging on? ...
    (microsoft.public.win2000.general)
  • Re: AWK problem need help
    ... The script is as follows: ... printf ("PAT:%s\n", $prev) ... The latter would print the field at whatever position "var" contains, and the whole record if var is zero or unset. ... Also, you don't need the " " as the final argument to splitas that's the default, and awk arrays start at 1, not 0 so "lastline" will always be empty. ...
    (comp.unix.shell)