Transaction Handling in DTS

[pankajv]

I have a DTS package, which has some tasks. Each task is suppose to copy the data from an excel sheet to a table in the database. In case we encounter any error in the execution of any step all the data copied in the previous tasks in already populated. We want to commit the changes only when all the steps are executed successfully. Please tell me if there is any way to handle this.

Thanks in advance.

 

[MissTipps]

If you go to Package > Properties you can use the Logging and Advanced tabs to set this up. (it should be fairly self explanatory when you get there)

Hope this helps.

Cheers

Clare

 

[MissTipps]

Hi

If you open the DTS package and go to Package > Properties you can use the Logging and Advanced tabs to set this up. (it should be fairly self explanatory when you get there)

Hope this helps.

Cheers

Clare

 

[pankajv]

Hi,

It does not work. From Package Properties -> Advanced tab, I set the "Use Transaction" and "Commit on successful package completion" options with the isolation level of "serializable", but still the changes are committed.

Thanks,

Pankaj