SSIS: How to disable task?

ssis sql-server-2008-r2 bids
kev picture kev · Dec 28, 2010 · Viewed 17.2k times · Source

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?

Answer

user756519 picture user756519 · Jun 11, 2011

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

Related questions

How to prevent SSIS from truncating the last field of the last data row in a flat file?

I have an SSIS package thats unzips and loads a text file. It has been working great from the debugger, and from the various servers its been uploaded to on its way to our production environment. My problem right now …

Read More
SSIS how to convert string (DT_STR) to money (DT_CY) when source has more than 2 decimals

I have a source flat file with values such as 24.209991, but they need to load to SQL Server as type money. In the DTS (which I am converting from), that value comes across as 24.21. How do I convert that field …

Read More
SSIS - OLE DB Destination - Table or Views load vs. Fast-load

From what I've read: Table or Views data access mode commits each row at a time as a transaction. Thus, making a package transferring 5 million rows take long (30+ minutes). Fast-load data access mode allows one to specify the batch rows …

Read More