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
APT_RDBMS_COMMIT_ROWS
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 69
- Joined: Tue Jan 18, 2005 12:15 am