SSIS SQL 2008 Data Flow continues even after failure
How is this possible? One step fails (Red box), but it still goes and executes the next step (The “Finished” box), even though it is conditional upon the successful
completion of the previous step (indicated by the Green arrow)!
To see a screenshot click
here.
ThanksAndy Abel
January 18th, 2011 4:58pm
Hi, what is the MaximumErrorCount property value to that failed object?
Thanks
Tiffosi!
Free Windows Admin Tool Kit Click here and download it now
January 18th, 2011 5:19pm
Hi, what is the MaximumErrorCount property value to that failed object?
Thanks
Tiffosi!
January 18th, 2011 5:19pm
Good suggestion, but MaximumErrorCount = 1 pretty much everything will be the default values.Andy Abel
Free Windows Admin Tool Kit Click here and download it now
January 18th, 2011 6:40pm
Good suggestion, but MaximumErrorCount = 1 pretty much everything will be the default values.Andy Abel
January 18th, 2011 6:40pm
Just to confirm. There is no expression on the precedence constraint.Russel Loski, MCT
Free Windows Admin Tool Kit Click here and download it now
January 18th, 2011 6:45pm
Just to confirm. There is no expression on the precedence constraint.Russel Loski, MCT
January 18th, 2011 6:45pm
No. There is no expression on the precedence constraint. It's set as follows:-
Evaluation operation: Constraint
Value: Success
Expression:
(and the Expression box is grayed out)
Andy Abel
Free Windows Admin Tool Kit Click here and download it now
January 18th, 2011 7:08pm
looks strange!
Could you delete that object and create again and try?Tiffosi!
January 18th, 2011 8:15pm
Can you also mention what is the error from the progress tab/log? I would check on the MaximumErrorCount on the package and the individual task/container.Rakesh Parida | MSFT
Free Windows Admin Tool Kit Click here and download it now
January 18th, 2011 8:49pm
Can you try setting Fail Package on Failure property to true on this task and try running the package again.
Regards,
DattaDattatrey Sindol
My Blog: Datta's Ramblings on Business Intelligence 'N' Life
The information provided here is "AS IS" with no warranties, and confers no rights.
Please mark the post as answered if it solves your problem.
January 19th, 2011 3:11am
pls set config
FailPackageOnFailure = true;
Free Windows Admin Tool Kit Click here and download it now
January 19th, 2011 3:24am
Even with FailPackageOnFailure = true; I get the same problem.
In fact, I've noticed that the last box ("Finished") goes Green long before the other boxes have executed! It's almost as though the precedence constraint is being ignored. So I've tried dropping the precedence constraint and recreating it, but the problem
remains! This has me worried about the reliability of the product if I can't rely on precedence constraints!
I am running "Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Developer Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3) ".
And I have done all the available Windows Updates.Andy Abel
January 19th, 2011 2:34pm
I remember this kind of issue with SSIS 2005.
And it got solved when I deleted the objects and created them again. Its kind weird!
As far as I remember the issue was related to the Lineage ID created for these objects.
Thanks.Tiffosi!
Free Windows Admin Tool Kit Click here and download it now
January 19th, 2011 6:19pm