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
Last activity: Oct 26, 2022, 06:56 PM