London roadshow follow up: Selective execution of SQL Server Integration Service Tasks and Transforms

  • Article

I had a question, at the London roadshow (8th June), which I wasn’t sure if I could answer reliably, so I promised to blog the answer.

The question: “Can I run selected (with mouse) tasks and transforms from inside the SQL Server Integration Services package designer?”

The answer I have is, for transforms, no you can’t.  For tasks you can – or at least just about.  You can select single or multiple tasks and then right mouse click and choose to 'disable' the selected task(s) – whereupon they appear greyed out.  Then when the package runs, those disabled tasks are not included in the run.