Hi Brian,

first I would like to thank you for the article.

I think this week or the last there was also an interesting discussion of the performance of the merge command, which is also a tool to be considered.

Even when it is very nice and comfortable to design packages with the visual component, connectors and dropdown list (almost only mouse clicks), most of the time scripts are needed to reach better performance. And that is always the problem with the DFT components and processing row by row.

I know the SQL scripts are more difficult to document, and a SSIS Package is harder to understand (when someone else has to modify something) but I always try to use the merge command or the temporary table solution.

Kind Regards,