SSIS: how to disable a task?

Question

I would like to save the job in the SSIS package, but enable / disable it when I want. Is there any way to do this?

Is this a big business?

Answer 1

On the Control Flow tab of the SSIS package, you can right-click the flow control task and select the Disable option to disable the task. See Screenshot # 1 . If the task is already disabled, the parameter will be read as Enable . See Screenshot # 2 .

However, tasks in the Data Flow Task cannot be disabled. See Screenshot # 3 .

Hope this helps.

Screenshot # 1:

Screenshot 2:

Screenshot 3:

Answer 2

You cannot disable tasks in the data stream, but you can right-click and disable tasks in the control stream. To get around the first problem, I copy the data flow task to the control flow and paste it. Disable the new data flow task, and then remove what I do not want to perform from the static steps of the data flow task. Then, at least, I still have the original steps for copying to the data stream that I use, since I want to add them.

Answer 3

You can use conditional split:

Condition 1: 1 == 1 will run the following tasks.
Condition 2: 1 == 2 will not run the following tasks.

Just change the conditions as necessary.

Answer 4

You can right-click on the task and select "Disable".

Answer 5

You can also select several tasks with the mouse by dragging a rectangle around them (click in the upper left corner, drag to the right to the right), right-click and select the pop-up menu with the "disable" option.

Answer 6

You need to make sure that the package is not currently running. But yes, there should be a right click.