September 29, 2010 at 2:50 am
Hi Guys
I have a stored procedure that update inserts and deletes data using cursors, this is executed by an sql task.
How do I configure the task to roll back if the task fails for some reason, the sql task is inside a sequence container and i have set transaction option to required.
Is this correct? and do I have set other option, I need the rollback to go back to the state before the sql task started
September 29, 2010 at 3:26 am
Hi,
Before the insert or update takes place attach a Execute SQL Task and Write BEGIN TRANSACTION.
AND if some error occurs divert to an Execute SQL Task and Write in it ROLLBACK TRANSACTION.
Regards,
Amar Sale
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
September 29, 2010 at 4:32 am
clucasi (9/29/2010)
Hi GuysI have a stored procedure that update inserts and deletes data using cursors, this is executed by an sql task.
How do I configure the task to roll back if the task fails for some reason, the sql task is inside a sequence container and i have set transaction option to required.
Is this correct? and do I have set other option, I need the rollback to go back to the state before the sql task started
Set Transaction property of Sequence container as required and that of EST as supported..:-):-)
Raunak J
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply