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!
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