Alberto Ferrari's Blog posts of 2007

Page 2 of 12 results

Distinct values in SSIS

Distinct is a partially blocking component that remove duplicates from one flow. Its main advantages against the sort component provided in SSIS are: Memory usage: Distinct does not cache the whole flow (as Sort does) but retains in memory only the distincts,  Read more