before loading values,can i check values with same [registrationNo,Course,semester(pk)] as we use sort technique to load distinct values??? i sorted registrationNo in student table but in registration table i can not do this as one registrationNo has registered into many courses in different semesters??? Reza I`m not using lookup here as i`ll use it dimension and fact tables,now i`m just loading data for L after ET :) mhassanshahbaz

The Sort component is capable of sorting over multiple columns. Will that suffice?http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

i have 3 values as my primary key RegistrationNo,semester,Course student cs-01/islamabad in semster sp07 registered to course cs101 cannot be registered again,but duplicate values occur in ETL,how to remove now??mhassanshahbaz