APT_RDBMS_COMMIT_ROWS

[snt_ds]

Hi,

I have parallel DS jobs that use ODBC stage to insert records to SQL server 2005 database and at the project level I have set APT_RDBMS_COMMIT_ROWS to 5000.

On the contratry to these settings, DBA confirmed that the commit is happening for every single row!!

Write Method = Upsert and I have a user defined SQL query to insert into the table.

Any ideas as to why there is a commit for every row. Am I missing some setting at DS level.

Thanks in advance

Sonia

[maheshsada]

Can you please post how the issue was resolved so that it can be useful for others