Alberto Ferrari has published on SQLBI.EU a Distinct component for SSIS. The big advantage is less memory used when you have few distinct values extracted from a large set of data. Component and source code are freeware.

Now the challenge is: how to improve the algorithm? Goals: more fast, less memory consumption…

Originally appeared on: http://sqlblog.com/blogs/marco_russo/archive/2007/02/12/a-distinct-component-for-ssis.aspx