THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SSIS » Distinct   (RSS)
Sorry, but there are no more tags available to filter with.
  • How to get Distinct Count in SSIS

    Almost one month ago I made a post about a brand new Distinct component for SSIS made by Alberto Ferrari and freely available on SQLBI.EU. The most used way to get distinct rows in a Data Flow  that I've seen is to use the Sort component, asking only for distinct rows (there is a check box for that in the standard edit dialog box). The Sort ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on March 9, 2007
  • A Distinct Component for SSIS

    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...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 12, 2007
Privacy Statement