Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Ignore errors on Execute Package task in SSIS

 
   Database Help (Home) -> DTS RSS
Next:  index for bitwise comparison?  
Author Message
CraigHB

External


Since: Jan 10, 2008
Posts: 40



(Msg. 1) Posted: Mon Mar 30, 2009 7:58 am
Post subject: Ignore errors on Execute Package task in SSIS
Archived from groups: microsoft>public>sqlserver>dts (more info?)

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.

 >> Stay informed about: Ignore errors on Execute Package task in SSIS 
Back to top
Login to vote
Todd C

External


Since: Jan 31, 2007
Posts: 106



(Msg. 2) Posted: Mon Mar 30, 2009 9:01 am
Post subject: RE: Ignore errors on Execute Package task in SSIS [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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:

> 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.
>

 >> Stay informed about: Ignore errors on Execute Package task in SSIS 
Back to top
Login to vote
CraigHB

External


Since: Jan 10, 2008
Posts: 40



(Msg. 3) Posted: Mon Mar 30, 2009 9:32 am
Post subject: RE: Ignore errors on Execute Package task in SSIS [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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!
 >> Stay informed about: Ignore errors on Execute Package task in SSIS 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Execute Process task fails after package is saved - Hi All I have a DTS package which uses an "Execute Process Task" to run a BAT file which is on the server's C:\. What happens is I setup the task by browsing to the file. And then test it by selecting "Execute Step". The execu...

SSIS Package execution errors - I am trying to execute an SSIS Package and the SSIS package threw the following errors: 1.) Executed as user: MyDomain\Administrator. ...00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 2:31:12 PM ..

Execute SSIS package from a sql stored procedure - How can I execute a SSIS package from a stored procedure? Thank you.

schedule Execute DTS 2000 Package SSIS and dtexec - I have a legncy DTS package when upgrading to SQL 2005, I used "SQL Business Intelligence Development Studio" to create a project, the control flow is "Execute 2000 DTS Package", by right click "Execute Task" of the contro...

Passing values from Inner variables to Outer variables to .. - In my SSIS package, there is Execute DTS 2000 Task, the DTS packages called from Execute DTS 2000 Task have GLOBAL variables (Shown in Inner variables). How to declare and Map the Values of Outer variables of DTS to Inner variable of SSIS ? Thanks in..
   Database Help (Home) -> DTS All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]