- SQL Server 2016
- C# Scripts
- DWH INTERVIEW QUESTIONS
- MS Dynamics AX 2012 R2 Video Tutorial
- Project / Work Support
- SQL SERVER DBA INTERVIEW QUESTIONS
- SQL SERVER DBA Video Tutorial
- SQL Server / TSQL Tutorial
- SQL Server Scripts
- SSIS INTERVIEW QUESTIONS
- SSIS Video Tutorial
- SSRS INTERVIEW QUESTIONS
- SSRS Video Tutorial
- TSQL INTERVIEW QUESTIONS
- Team Foundation Server 2013 Video Tutorial
- Team Foundation Server 2015 Video Tutorial
- Windows 10
- Windows Server 2012 R2 Installation Videos
SSIS - How to Disable/Enable Task/s In SSIS Package
In SSIS Package you can disable the Tasks. Any Task or Container that you place in Control Flow Pane can be disabled and you can leave the Task or Tasks enable which one you want to run. This feature is very helpful while debugging package without deleting the Tasks. Once you are done with debugging , you can enable the Tasks.
Tasks/Containers can be disabled. You can not go inside the Data Flow Task and disable a transformation or more than one Transformations.
Fig 1: SSIS Package with Different Tasks
Let's say we want to debug above SSIS Package but we don't want to execute Foreach Loop Container and "Data Flow Task_Load data Into Staging Tables" Data Flow Task.
We can simply Right Click on any of the Tasks/Containers and then click Disable.That will do the magic for us and disable the script.
Fig 2: How To Disable Task/Container with Tasks in SSIS Package
Fig 3: Disable/Enable Tasks/Containers in SSIS Package
If you execute SSIS Package, the disabled Tasks will not run. To enable Task/ Container, Right Click on it and click Enable.
Fig 4: Enable Disabled Tasks in SSIS Package