Sample Header Ad - 728x90

Guaranteed rollback in SSIS

0 votes
2 answers
2102 views
I'm trying to create a job in SSIS to truncate a table, read from a data source and rewrite the table, so only 2 steps (1 Truncate and 2 Select + Insert). I need to guarantee a Truncate's Rollback in the event that the insert has errors. I tried with the sequence container and the TransactionOption but SSIS doesn't want to cooperate. PS I can't do too many operations because I have millions of records and I need rapid performance.
Asked by Giorgia Grossi (1 rep)
Oct 26, 2022, 02:06 PM
Last activity: Oct 26, 2022, 06:56 PM