hi
i could not access the distinct block as shown in ur documents . i have sucessfully reached till commnd prompt for GACUTIL - I Distinct.dll.
i got message as assembly sucessfully added to cache
Using Distinct part as specified in ur document was not followed by me .i am a newbie and was trying for customizing of my code to .dll file.
Plz rexplain me how do i get tht distinct block added to my toolbox of data flow ssis so tht i can drag and drop wherever applicable to make the transformation as described
i have pasted the part of ur doc
plz reply
thks in advance
Installation
Installation is very simple:
No installer for the moment… sorry.
Using Distinct
Using Distinct is straightforward: just insert the transformation where you would have used a Sort one, like in this diagram:
Configuring Distinct is easy as to double click on it to reach the component editor that let you choose the columns you want to use in order to take their distinct values:
Component signature
The component needs to have a strong name and hence a signature file. We have provided a free snk file named SqlBiFree.snk, please note that any change in the signature needs an update to the declaration of the Distinct class where you must declare the public key of the assembly to let SSIS invoke the component editor.
Final considerations
Distinct is a nice component that solves memory problem for taking distinct values from a flow. It took a single day to write it, starting from the samples provided by Microsoft. The real lesson here is that it is quite always easier to write your components when you have a specific need instead of trying to adapt the existing ones.
I am pretty sure that somebody – studying the sources – will discover a faster algorithm for detecting distinct values in a flow, in the case his/her contribution will be highly appreciated.
During more tests, Marco Russo discovered an easier and faster way to get Distinct that is to use an Aggregate component instead of a Sort one. Using aggregate memory usage is very low and the SSIS package runs faster so, at the end, the usefulness of this component is just to use it as a sample, I think I'll use Aggregate to take distincts from now on. :)