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

Jamie Thomson — Tue, 14 Jun 2005 22:28:46 GMT

Mat,
You can also right-click on a task in the control-flow and select "Execute Task" exactly as you could for DTS.
Is this not what the person was asking? If you want to run more than 1 task then you're correct, the only option is to disable all the other components. Perhaps a "Run from here" option on the right-click context menu would help.

Certainly you can't for data-flow components and it makes sense if you think about it. After all, what data would the component carry out its operation on and where would it put it afterwards. Don't underestimate the value of breakpoints in a data-flow however - this is the closest you can get to testing a cmponent in isolation.

-Jamie