dbTalk Databases Forums  

SSIS: do not fail foreach loop if package fails?

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


Discuss SSIS: do not fail foreach loop if package fails? in the microsoft.public.sqlserver.dts forum.



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

Default SSIS: do not fail foreach loop if package fails? - 07-25-2008 , 02:30 AM






Hi,

i have a foreach loop that loops through ADO recordset.

In that loop i have a execute package task (lets call it SubmitData), which
executes another package.

If at one iterration package SubmitData fails, foreach loop would continue?
Because now it fails after first packages failure?

I though tat using FailParentOnFailure would help - but no. I do not want to
increase maximum error count, as in foreach loop i migh have as many as 10
000 records ( or even more). I simply want that execution of foreach would
loop through all records in recordset, despite the output of SubmitData
package. How can i do that?



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

Default RE: SSIS: do not fail foreach loop if package fails? - 07-25-2008 , 07:37 AM






Look for the property ForceExecutionResult (Under Misc category).

You can set the task to always report to its parent container that it
succeeded, regarless of what actually happened inside it.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"meska" wrote:

Quote:
Hi,

i have a foreach loop that loops through ADO recordset.

In that loop i have a execute package task (lets call it SubmitData), which
executes another package.

If at one iterration package SubmitData fails, foreach loop would continue?
Because now it fails after first packages failure?

I though tat using FailParentOnFailure would help - but no. I do not want to
increase maximum error count, as in foreach loop i migh have as many as 10
000 records ( or even more). I simply want that execution of foreach would
loop through all records in recordset, despite the output of SubmitData
package. How can i do that?




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

Default RE: SSIS: do not fail foreach loop if package fails? - 07-25-2008 , 07:37 AM



Look for the property ForceExecutionResult (Under Misc category).

You can set the task to always report to its parent container that it
succeeded, regarless of what actually happened inside it.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"meska" wrote:

Quote:
Hi,

i have a foreach loop that loops through ADO recordset.

In that loop i have a execute package task (lets call it SubmitData), which
executes another package.

If at one iterration package SubmitData fails, foreach loop would continue?
Because now it fails after first packages failure?

I though tat using FailParentOnFailure would help - but no. I do not want to
increase maximum error count, as in foreach loop i migh have as many as 10
000 records ( or even more). I simply want that execution of foreach would
loop through all records in recordset, despite the output of SubmitData
package. How can i do that?




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

Default RE: SSIS: do not fail foreach loop if package fails? - 07-25-2008 , 07:37 AM



Look for the property ForceExecutionResult (Under Misc category).

You can set the task to always report to its parent container that it
succeeded, regarless of what actually happened inside it.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"meska" wrote:

Quote:
Hi,

i have a foreach loop that loops through ADO recordset.

In that loop i have a execute package task (lets call it SubmitData), which
executes another package.

If at one iterration package SubmitData fails, foreach loop would continue?
Because now it fails after first packages failure?

I though tat using FailParentOnFailure would help - but no. I do not want to
increase maximum error count, as in foreach loop i migh have as many as 10
000 records ( or even more). I simply want that execution of foreach would
loop through all records in recordset, despite the output of SubmitData
package. How can i do that?




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

Default RE: SSIS: do not fail foreach loop if package fails? - 07-25-2008 , 07:37 AM



Look for the property ForceExecutionResult (Under Misc category).

You can set the task to always report to its parent container that it
succeeded, regarless of what actually happened inside it.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"meska" wrote:

Quote:
Hi,

i have a foreach loop that loops through ADO recordset.

In that loop i have a execute package task (lets call it SubmitData), which
executes another package.

If at one iterration package SubmitData fails, foreach loop would continue?
Because now it fails after first packages failure?

I though tat using FailParentOnFailure would help - but no. I do not want to
increase maximum error count, as in foreach loop i migh have as many as 10
000 records ( or even more). I simply want that execution of foreach would
loop through all records in recordset, despite the output of SubmitData
package. How can i do that?




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

Default RE: SSIS: do not fail foreach loop if package fails? - 07-25-2008 , 07:37 AM



Look for the property ForceExecutionResult (Under Misc category).

You can set the task to always report to its parent container that it
succeeded, regarless of what actually happened inside it.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"meska" wrote:

Quote:
Hi,

i have a foreach loop that loops through ADO recordset.

In that loop i have a execute package task (lets call it SubmitData), which
executes another package.

If at one iterration package SubmitData fails, foreach loop would continue?
Because now it fails after first packages failure?

I though tat using FailParentOnFailure would help - but no. I do not want to
increase maximum error count, as in foreach loop i migh have as many as 10
000 records ( or even more). I simply want that execution of foreach would
loop through all records in recordset, despite the output of SubmitData
package. How can i do that?




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

Default RE: SSIS: do not fail foreach loop if package fails? - 07-25-2008 , 07:37 AM



Look for the property ForceExecutionResult (Under Misc category).

You can set the task to always report to its parent container that it
succeeded, regarless of what actually happened inside it.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"meska" wrote:

Quote:
Hi,

i have a foreach loop that loops through ADO recordset.

In that loop i have a execute package task (lets call it SubmitData), which
executes another package.

If at one iterration package SubmitData fails, foreach loop would continue?
Because now it fails after first packages failure?

I though tat using FailParentOnFailure would help - but no. I do not want to
increase maximum error count, as in foreach loop i migh have as many as 10
000 records ( or even more). I simply want that execution of foreach would
loop through all records in recordset, despite the output of SubmitData
package. How can i do that?




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

Default RE: SSIS: do not fail foreach loop if package fails? - 07-25-2008 , 07:37 AM



Look for the property ForceExecutionResult (Under Misc category).

You can set the task to always report to its parent container that it
succeeded, regarless of what actually happened inside it.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"meska" wrote:

Quote:
Hi,

i have a foreach loop that loops through ADO recordset.

In that loop i have a execute package task (lets call it SubmitData), which
executes another package.

If at one iterration package SubmitData fails, foreach loop would continue?
Because now it fails after first packages failure?

I though tat using FailParentOnFailure would help - but no. I do not want to
increase maximum error count, as in foreach loop i migh have as many as 10
000 records ( or even more). I simply want that execution of foreach would
loop through all records in recordset, despite the output of SubmitData
package. How can i do that?




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

Default RE: SSIS: do not fail foreach loop if package fails? - 07-25-2008 , 07:37 AM



Look for the property ForceExecutionResult (Under Misc category).

You can set the task to always report to its parent container that it
succeeded, regarless of what actually happened inside it.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"meska" wrote:

Quote:
Hi,

i have a foreach loop that loops through ADO recordset.

In that loop i have a execute package task (lets call it SubmitData), which
executes another package.

If at one iterration package SubmitData fails, foreach loop would continue?
Because now it fails after first packages failure?

I though tat using FailParentOnFailure would help - but no. I do not want to
increase maximum error count, as in foreach loop i migh have as many as 10
000 records ( or even more). I simply want that execution of foreach would
loop through all records in recordset, despite the output of SubmitData
package. How can i do that?




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.