1

I have an SSIS package called Main_Flow that executes several other packages in order.

What I'd like to do is to somehow parametrise the enabling/disabling of packages in the main flow. This way I can choose to skip certain tasks based on value of parameters upon execution.

How can I ensure that a task can be skipped if DisabeTaskA parameter is set to TRUE?

It is important to emphasize that if I disable a package in the middle of the linear sequence, although this task would be skipped this does not mean any of the next packages should be skipped (unless I opted to disable them). That is, the skip shouldn't break out of the sequence.

1 Answer 1

2

Actually this is way simpler than I thought.

  1. Right-click the task and choose Parametrize...
  2. Choose the property to be parametrized. From there you can choose an existing parameter or create a new one. It is easy-peasy.

In this case I created a boolean parameter and gave it the default value of FALSE. Then I bound it to the property Disable of the task. When the task is disabled it skips that task but any connections after the task continues.

1
  • Upvoted. Simple and helped me out. Thanks.
    – Dave Brown
    Commented Sep 25, 2019 at 10:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.