here is my situation I have to create a DTS package which reads the data from a table and checks whether the composite key of the data which I am transferring matches with the destination table.Now my doubt is where we check the condition for the compositekey match,is it in the transform data task or is their any other way.will be thankful if you gusy throw some ideas.
