How to only sync the new records from table A to table B in SSIS?

Vote count:

0

Does any one how can I only sync the new records from table A to table B in SSIS?

I have 2 tables which table A and table B. Table A will be update time to time from user. However, records from table B is sync from table A every 30 mins. I have created a SSIS job to do the sync, see below for more details:

I have an issue here, every times when I'm ruining the job, it will copy all data from table A and insert into table B (this causing duplicate records had been insert). Any way that I can set the job so that it will only sync the new records into table B?

asked 52 secs ago

Jin Yong

6,430