Distinct Component for SSIS

If anyone has read Jamie Thomson’s piece A Distinct Component Please! .. I would like to ititerate his frustration. This seems like a simple thing for the powers that be on the business intelligence end to come up with. Of course, there have been some simple illustrations on how to do this via hash-tables and the script component but I would have to wonder how these scale for very large sets like the ones in which I am used to dealing with. Of course, there are already third party components in the works like NSort but this seems like such a simple component that not having it as a default in Business Studio is ridiculous. Of course, if anyone has a really good piece of custom code that they have implemented with the script component that scales smoothly then I would appreciate dropping me an email.

Leave a Reply

Your email address will not be published. Required fields are marked *