Newbie SSIS
Programmer
In my ETL I have 4 tasks as below
1) sql task - truncate tbl_1
2) DFT load data to tbl_1 (batch n commit size 10, 000)
3) sql task - truncate tbl_2
4) DFT load data to tbl_2
I have enabled checkpoint but issue is that if it fails at task 2 few rows might have got inserted and committed. On restarting ETL based on the checkpoint xml file saved it restarts from task 2 which means the inserted rows get re-inserted again. How to encapsulate task 1+2 and task 3+4 into a transaction unit.
Kindly advise.
Thanks.
1) sql task - truncate tbl_1
2) DFT load data to tbl_1 (batch n commit size 10, 000)
3) sql task - truncate tbl_2
4) DFT load data to tbl_2
I have enabled checkpoint but issue is that if it fails at task 2 few rows might have got inserted and committed. On restarting ETL based on the checkpoint xml file saved it restarts from task 2 which means the inserted rows get re-inserted again. How to encapsulate task 1+2 and task 3+4 into a transaction unit.
Kindly advise.
Thanks.