10

I would like to keep a task in an SSIS package but enable/disable it when i please. Is there a way to do this?

Is this big business?

kev
  • 101
  • 1
  • 1
  • 3

6 Answers6

12

On the SSIS package's Control Flow tab, you can right-click on a control flow task and select Disable option to disable the task. Refer screenshot #1. If the task is already disabled, the option will read as Enable. Refer screenshot #2.

However, the tasks within Data Flow Task cannot be disabled. Refer screenshot #3.

Hope that helps.

Screenshot #1:

1

Screenshot #2:

2

Screenshot #3:

3

  • 1
    Microsoft said in 2010, they wouldn't be adding disable to the `Data Flow Task` which is a shame: [link](http://connect.microsoft.com/SQLServer/feedback/details/410210/ssis-add-enable-disable-within-data-flow-tab) – PeterX Nov 16 '12 at 04:14
  • is there any way to see that it's disabled besides right clicking and noticing that it says "enable" instead of "disable"? Seems like this could be a very frustrating thing to troubleshoot if it's disabled and you didn't know it. – jessieloo Apr 22 '14 at 12:46
  • nevermind... Now I see that it turns gray when it's disabled. I was running the package so it didn't change to gray right away. – jessieloo Apr 22 '14 at 12:50
  • It sucks that Microsoft doesn't prioritize the ability to disable Data Flow sub-components. It's valuable yet it would probably take a jr. programmer only 4 hours. – Pete Alvin May 25 '16 at 18:55
  • 2
    2019 and still the same: Disabling Data Flow sub-components is not available. – wp78de Apr 05 '19 at 20:27
10

You cannot disable tasks in a data flow, but you can right click and disable tasks in a control flow. To get around the first problem, I copy the dataflow task in the control flow and paste it. Disable the new dataflow task and then delete what I don't want to execute out of the old dataflow task steps. Then at least I still have the orginal steps to copy into the data flow I'm using as I want to add them.

HLGEM
  • 94,695
  • 15
  • 113
  • 186
8

You can use a Conditional Split:

Condition 1: 1 == 1 it will run the following Tasks.
Condition 2: 1 == 2 it will not run the following Tasks.

Just Change conditions as needed.

wp78de
  • 18,207
  • 7
  • 43
  • 71
Alexander
  • 81
  • 1
  • 1
1

You should be able to right-click on the task and select Disable.

Randy Minder
  • 47,200
  • 49
  • 204
  • 358
1

You can also select multiple tasks with the mouse by dragging a box around them (click on upper left corner, drag to lower right,) right-click, and get the popup menu with the 'disable' option.

Beth
  • 9,531
  • 1
  • 24
  • 43
0

You need to make sure the package isn't currently executing. But yea, should be a right click away.

RailRhoad
  • 2,128
  • 2
  • 25
  • 39