ram20071985
Newbie
Points: 7
More actions
September 10, 2010 at 6:04 am
#223811
In my package I have three execute sql tasks each one has stored procedures and insert/update data into tables in sql server.
I want roll back the insert/updated data when done by first execute sql task when second execute sql task fails and so on.
jboudinot
Mr or Mrs. 500
Points: 558
September 10, 2010 at 8:47 am
#1219235
I believe you put the execute sql tasks in a sequence container and set the TransactionOption property of the container to required.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply