Hi, I have a SSIS OLEDB source control which get the 5 columns. I want to select 3 out of the 5 and perform a distinct on the columns. Thanks in advance.

Just use a normal Select distinct query as your source SELECT DISTINCT Col1, col2,col3 FROM tablenameChuck Pedretti | Magenic North Region | magenic.com

i cant. I am get 5 columns and then using multicast to store 3 colums in table A and other 2 columns in table B. So i want to perform distinct select after the multicast to create two destination streams

Try adding sort with remove duplicate options..Tamilselvan