Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Newbie SSIS
- Order by date
-
Using checkpoint in SSIS ETL for DFTs
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...- Newbie SSIS
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Integration Services (SSIS)
