continue my package even in Failure

• samirca007

  SSC-Addicted

  Points: 417

  More actions

  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?

  

  • This topic was modified 5 years, 3 months ago by samirca007.
  • This topic was modified 5 years, 3 months ago by samirca007.

  Attachments:

  You must be logged in to view attached files.

• ktflash

  Default port

  Points: 1400

  More actions

  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.

  

   

  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

• Phil Parkin

  SSC Guru

  Points: 247172

  More actions

  April 2, 2020 at 1:17 pm

  #3739986

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

  ---

• samirca007

  SSC-Addicted

  Points: 417

  More actions

  April 2, 2020 at 1:22 pm

  #3739989

  thanks