DSXchange

Hi ,

I am executing a stored procedure by passing parameters from a dataset file.No COMMIT statements are given in the stored procedure. Intention is to rollback all records processed by this job in case of any failure. I have set the transaction size to '0' . My question is whether COMMIT happens if the job gets completed successfully or do we need to explicitly mention this ?

Please suggest...

I don't know for certain off the top of my head, but it sure seems like it would be quicker to simply test it yourself than ask here. And then let us know the answer, of course.