Re: ActiveX Task - Status = Failure or Success

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I'd go for a simpler approach. Let it fail, and then exit the package. Use a
Job step retry to implement the 15 minute wait. Overall the job result
should be success.

If you must, you can mess around with workflow, but you cannot change the
result, you must prevent the failure in the first place. Take a look at
these for some ideas.

How can I check if a file exists?
(http://www.sqldts.com/default.aspx?211)

Skip the execution of an individual Task
(http://www.sqldts.com/default.aspx?214)


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Jon Derbyshire" <JonDerbyshire@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:82C722EB-5AF1-4EB8-AA4C-8CB5D409B82C@xxxxxxxxxxxxxxxx
> Hi,
>
> I have a DTS that checks to see if a file exists.
>
> The first ActiveX Script doe sthe initial check, and if not found reports
> failure.
>
> On failure of that task, I have a Execute SQL Task to wait 15 minutes,
> which
> then on completion runs a second ActiveX Script to set the first Script
> back
> to waiting.
>
> This creates a loop scenario.
>
> However, if the first script fails to find the file, (i.e. reports
> failure),
> but then finds it on the second loop (i.e. reports success), on completion
> of
> the DTS the script shows as though it filed, although it obviously
> didnt...
>
> How can I make DTSTaskExecResult_Success actaully report success after an
> initial failure???
>
> Jon


.

Relevant Pages

  • Re: ERROR: No space left on device /dev/stdout
    ... awk: close failed on file /dev/stdout ... If failure had no penalty success would not be a prize (T. ... my conclusion is that the stdout is indeed a plain file. ... Can you please give an example of a script designed to clean up output ...
    (comp.os.linux.development.system)
  • Re: Help with a stragegy for diagnosis
    ... The failure of the openwas detected by the code itself ... script that reads the file. ... arose, the files were not apparently created. ... on normal or test transactions. ...
    (comp.lang.perl.moderated)
  • Re: sysrc -- a sysctl(8)-like utility for managing /etc/rc.conf et. al.
    ... Say someone wanted to call my script but wanted to mask it to always return ... sysrc foo; reboot ... echo "FAILURE: $FAILURE" ...
    (freebsd-hackers)
  • Re: xen, raid and initramfs failure
    ... Failure: failed to load Module 1 no such module ... the above section and just putting in a bunch of modprobes and it ... Can you edit the script, add set -x at the top and post the output? ...
    (Debian-User)
  • Re: Finetuning: Remote Shutdown with WMI, some errors occur.
    ... About your article in Windows IT Pro, maby it's a good thing to post it (or ... script, it now works with the script i provided. ... you can guarantee that it will have a high failure rate. ... or a host of other minor reasons, I suggest momentarily suppressing errors ...
    (microsoft.public.windows.server.scripting)