SSIS Incremental Extract and Load for Multiple Tables in one Job / Pipeline

Question

Greetings,

We have one Source System DB (SQL) which had 120 Tables. I want to Extract all Tables (120) from Source Database and then Load them in Target Database (which is also SQL).

Key Requirements:

1. I want to run this as Job, one time daily
2. Incremental data updates can happen from all source tables to target tables after initial full data load
3. No transformation Required

Please assist.

Thanks and Regards

Dinesh Sharma

Answer 1

Hi @dinesh kumar sharma

Do you have a column for datetimestamp? If yes you may update the tables with the datetimestamp via Execute SQL Task.

Here is also a same thread you may take a reference to..

https://stackoverflow.com/questions/37197332/best-incremental-load-method-using-ssis-with-over-20-million-records

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.