Getting Started with Adobe After Effects - Part 6: Motion Blur
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.
Loading

1st Prize - Apple iPad


SQLServer Quiz 2011 - SSIS package execution error bypass

  • The goal is to create package and execute successfully. Please note that the package should continue execution even a task in execution sequence fails. We may give immediate solution by setting up ForceExecutionResult property to success. But, that is not the requirement.

    Posted on 06-26-2011 00:00 |
    Ayyappan Thangaraj
    564 · 0% · 64

5  Answers  

Subscribe to Notifications
  • Score
    10

    In execution sequence, we can set "On Completion" precedence constraint instead of "Success". One can also set the "MaximumErrorCount" property of the container as 0 so that it will not fail in case any task within this container fails and execution proceeds on.

    Replied on Jun 26 2011 5:09AM  . 
    Nitesh Rai
    135 · 1% · 361
  • Score
    6

    Please increase the MaximumError Count on Package Properties or any Container control where you feel, you will get error(s).

    Replied on Jul 6 2011 7:12AM  . 
    Alpesh Patel
    36 · 5% · 1663
  • Score
    7

    Constraint contains 3 values - 1. Success 2.Failure and 3. Completion.

    Select "Completion" will do the needful.

    Thanks Manoj

    Replied on Jul 13 2011 5:49AM  . 
    Manoj Bhadiyadra
    153 · 1% · 315
  • Score
    8

    I would use the Completion constraint on the connectors between tasks, because this shows my aim to the developer who reads my package.

    In addition to this, I would set the MaximumErrorCount property of the package to 0.

    If the package is called from an outer package, the MaximumErrorCount property has to be set to 0 as well, as the failure of the package will be reported to the parent regardless of my settings in the package.

    Replied on Jul 13 2011 9:42AM  . 
    Guenter
    28 · 6% · 1838
  • Score
    4

    you can create errorhandler OnError at the current task and set the system variable "Propagate" to False. that will prevent any error message to raised to upper level (container etc)

    edit: dont forget to add annotation stated that the errorhandler MUST exists eventhough theres no other tasks inside to prevent accidental deletion

    Replied on Jul 13 2011 9:44PM  . 
    Paul Hutagalung
    867 · 0% · 33

Your Answer


Sign Up or Login to post an answer.
Please note that your answer will not be considered as part of the contest because the competition is over. You can still post an answer to share your knowledge with the community.

Copyright © Rivera Informatic Private Ltd.