dbTalk Databases Forums  

Ignore errors on Execute Package task in SSIS

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


Discuss Ignore errors on Execute Package task in SSIS in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
CraigHB
 
Posts: n/a

Default Ignore errors on Execute Package task in SSIS - 03-30-2009 , 09:58 AM






In an SSIS package, I have a For Loop Container task with the EvalExpression
set to true (so that it runs forever). If any tasks inside the For Loop
Container fail, then the package must fail -- except for the Execute Package
task (that calls a child package). If that fails, then the parent package
should move onto the next task.

I tried setting the MaximumErrorCount of the Execute Package task to 0, but
that didn't help. I tried setting the MaximumErrorCount of the For Loop
Container task to 0, but that ignores the errors of all the tasks within the
For Loop Container task.

Any idea how I can ignore errors on only the Execute Package task -- within
a For Loop Container.


Reply With Quote
  #2  
Old   
Todd C
 
Posts: n/a

Default RE: Ignore errors on Execute Package task in SSIS - 03-30-2009 , 11:01 AM






Have you tried messing with the properties of the task(s) inside the loop:
FailPackageOnFailure
and
FailParentOnFailure
?

Sounds like they would be quite useful in this situation!
=====
Todd C


"CraigHB" wrote:

Quote:
In an SSIS package, I have a For Loop Container task with the EvalExpression
set to true (so that it runs forever). If any tasks inside the For Loop
Container fail, then the package must fail -- except for the Execute Package
task (that calls a child package). If that fails, then the parent package
should move onto the next task.

I tried setting the MaximumErrorCount of the Execute Package task to 0, but
that didn't help. I tried setting the MaximumErrorCount of the For Loop
Container task to 0, but that ignores the errors of all the tasks within the
For Loop Container task.

Any idea how I can ignore errors on only the Execute Package task -- within
a For Loop Container.


Reply With Quote
  #3  
Old   
CraigHB
 
Posts: n/a

Default RE: Ignore errors on Execute Package task in SSIS - 03-30-2009 , 11:32 AM



Yes, Todd -- that's it. I set the FailPackageOnFailure to true for the tasks
that I want to cause the package to stop if they fail. Thanks!

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.