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
Read More...