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.
You can do this with a Data Driven Query Task. In my opinion though, it would be better to transfer the data to a staging table (if it is on another box) and then write a stored procedure to do what you require. This would also be much quicker than using the Data Driven Query Task. Hope this helps.
Can you explain more precisely how can I do this by a staging table my condition for validity of the data is that, to reflect the table name for ease of use for the user. If the composite key in the incoming table does not match a composite key row in the other it is a reject.
