Alberto Ferrari wrote an interesting post about the need of more properties to control the behavior of a Merge component in Integration Services (SSIS). This apparent simple problem becomes very important in large data warehouses. I hope that someone in Redmond will consider all these possible improvements…

Originally appeared on: http://sqlblog.com/blogs/marco_russo/archive/2007/04/11/the-need-for-a-better-merge-component-in-ssis.aspx