I have been so used to use int identity fields as primary key for any table and to believe it’s the fastest way to define a clustered primary key that I never thought this can cause serious performance problems to SSIS. Until I tested it and discovered  Read more

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