@jayd3vl This is poorly explained in the documentation (under the section ArcSDE Geodb Writer Parameters). This parameter fine tunes the timing of the commit, either immediately after the last transaction, or just at the start of the next transaction. I have to admit I don't understand the subtle difference there.
To do what you want to do - roll back if there is any failure then you need to set the Feature per Transaction to a very high value - greater than the number of records you expect to write. Then the commit will only occur at the end of the data load. This can have consequences for your database tmp file sizes that might need DBA assistance (I know that can be an issue on Oracle, I'm not sure about SQL Server).
Another approach is to use staging tables to ensure that everything worked and then move the data to production. We talk a little bit about these issues in this webinar.
@jayd3vl This is poorly explained in the documentation (under the section ArcSDE Geodb Writer Parameters). This parameter fine tunes the timing of the commit, either immediately after the last transaction, or just at the start of the next transaction. I have to admit I don't understand the subtle difference there.
To do what you want to do - roll back if there is any failure then you need to set the Feature per Transaction to a very high value - greater than the number of records you expect to write. Then the commit will only occur at the end of the data load. This can have consequences for your database tmp file sizes that might need DBA assistance (I know that can be an issue on Oracle, I'm not sure about SQL Server).
Another approach is to use staging tables to ensure that everything worked and then move the data to production. We talk a little bit about these issues in this webinar.
Thanks Mark for your feedback. In this case, i have a small feature class with just 200 records, I did push the Feature to write Per Transaction to a very high number but I am not getting the expected result. Here are the settings that I am using for the writer, not sure if I further need to tweak it. Thanks Jay
