DataBase transaction control

[s_avneet]

Hello All.

I am writing records into SQL Server DB from a file. How can i achieve the transaction control?

For me, even if a single record in the payload file fails, the entire transaction needs to be rolled back.

Is there a way i can achieve this??

[ray.wurlod]

You can set the Transaction size (row count) to 0.

Note, however, that all rows thereby become one transaction. Is SQL Server configured to handle transactions of this size?