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 SQL Server MVP and a independent consultant with the title of Business Intelligence/Data Warehouse/Master Data Management Architect and Developer, specializing in the Microsoft SQL Server BI stack.
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

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>