SSIS – Can’t Enable/Disable within Data Flow Tab

This is my biggest gripe with SSIS: I have a data flow task, and within that I’m pulling data from multiple sources into multiple destinations, with a few performing data flow transformations.  While testing, I want to disable some of the components.  You can’t.  You can disable any task in a control flow, but not the data flow.

There is a Connect item on this: SSIS – Add Enable/Disable within Data Flow Tab.  It seems this won’t be “fixed” in Denali either.

So the only solution is to copy the data flow task, or the entire package, and delete the appropriate components.

Please Microsoft, make this better!

About James Serra

James is a big data and data warehousing solution architect at Microsoft. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 25 years of IT experience.
This entry was posted in SQLServerPedia Syndication, SSIS. Bookmark the permalink.

One Response to SSIS – Can’t Enable/Disable within Data Flow Tab

  1. I second this gripe!!!!
    I the past I have even go so far as to develop each source data flow separately in their own SSIS package and then bring them back together, if I need to, once I was completely happy with each data flow.
    My biggest gripe is no real SSIS expression editor!! SSIS expressions can get pretty complex in the wrong hands!
    On the good side in Denali you can ‘undo’ changes that is life saver Undo and Redo. This long overdue functionality finally made it into SSIS. Now you can use CTRL+Z or CTRL+Y to undo and redo latest changes.

    Multiline Annotations. Another minor but annoying issue from earlier versions. No more jumping to text editors or CTRL+ENTER in order to get annotations in multiple lines of text. Just hit enter