DSXchange

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??

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?