Re: Package Success even with Task Failure

#1

Why not turn off the email on error if you don't want it?
There is no way to override the result, so can you test for the condition
that will subsequently cause failure, and hence skip the task to prevent the
failure happening?

One kludge would be to call the package from a parent package using the
Execute Package Task. Failed task will not bubble up to the parent package,
unless you set Fail on first error on in the child package.

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

"Don Stanley" <DonStanley (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have a DTS package that has a transform step that loads FoxPro data and
transforms it to SQL Server, then runs some other SQL tasks. This package
is
scheduled to run every five minutes and send an e-mail on error. However,
I
don't want to get notified if just the FoxPro transform fails since it
seems
to about every 20 times (every hour in my case). Is there a way I can set
the package result to "Success" even if that particular task fails? I've
tried using a sub-task with an "On Failure" precedent, and it executes,
but
the package result is stiull "Failure".

Thanks,

Don

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

Re: Package Success even with Task Failure

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

Re: Package Success even with Task Failure - 08-27-2004 , 04:29 AM