Got duplicated records after running scheduled DTS
I have a scheduled a DTS with Data Query Task which perform add, update and unsubscribe function for a mailing list customer database. Any customer asctivities (new subscribe/update detail/unsubscribe) will be logged down in "customer_logs" table, a dedicated field "log_type" is used to indicated what that of activitities inside.
My scheduled DTS is used to migrate the data from "customer_logs" to "customer" table based on type of the activities. I have designed 2 data query task inside (one for add+update and another one for unsubscribe function).
One strange thing that I found is when I run the DTS, I found duplicated records in "customer" table, when I check back the records in "customer_logs", there is no duplicated records. This is strange, can any help??