Post reply

continue my package even in Failure

  • April 2, 2020 at 12:50 pm

    #3739957

    Good morning all ,

    I start in ssis and I have a request that I can't find a solution

    I have a 3 step package (Step1 ----> Step2 ---> Step3)

    I'm looking to go to Step 3 regardless of the status of step 2 (succed or Failed)

    Who can help me please on a solution?

    Sans titre (1)

    • This topic was modified 4 years, 7 months ago by  samirca007.
    • This topic was modified 4 years, 7 months ago by  samirca007.

    Attachments:
    You must be logged in to view attached files.

  • April 2, 2020 at 12:57 pm

    #3739961

    If you edit the Taskflow, isnt there a 3rd option other than success/fail?

    Sorry for the german version but there should be something called completeance or something.

    Unbenannt

     

    What else could work is if you use a dummy Task that does nothing and after doing nothing continues doing the process that you want it to continue with an OR Clause

    I want to be the very best
    Like no one ever was

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

  • April 2, 2020 at 1:17 pm

    #3739986

    Yes, change the precedence constraint from step 2 to step 3 to 'Completion'.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • April 2, 2020 at 1:22 pm

    #3739989

    thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply