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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics