Sunday, February 19, 2012

Column detach task ?

Sometimes you have some columns in the dataflow that you at some point in the flow doesn't need in the further flow. So maybe a tast or an option for disabling columns that are no longer in use

Why do you think this would be of benefit? If its for disabling those columns at design-time then I think its a good idea. I think "disabling|" is the wrong word however, "hiding" would be more appropriate!

This wouldn't have any benefit on runtime performance because the query plan will still allocate memory buffer space for those columns and that buffer space will still be occupied even after the components that use the column have finished executing.

As ever, if you have a suggestion for future enhancement then register it at the feedback center (http://lab.msdn.microsoft.com/productfeedback/default.aspx). Then put a link to it up here - I would vote for a request to be able to hide columns in the designer.

-Jamie

No comments:

Post a Comment