Page 1 of 1
Sql server Commit
Posted: Mon Aug 25, 2008 8:45 am
by snt_ds
In sqlserver target, how to commit records all at once (single commit)
Thanks in Advance
Posted: Mon Aug 25, 2008 3:45 pm
by ray.wurlod
What stage type are you using? Usually this is by setting transaction size to 0 (which means "all rows are one transaction").
Posted: Thu Sep 04, 2008 8:20 am
by snt_ds
We are using SqlServer Enterprise stage.
so please let me know what options to use and where?
Posted: Thu Sep 04, 2008 3:31 pm
by ray.wurlod
An environment variable governs transaction size. A search will find its name for you.
Posted: Wed Sep 10, 2008 6:25 am
by snt_ds
I coudn't find any ENV variable for the SQL server Transcation commit.
In SqlServer Enterprise stage there is a option (Insert Array Size).
If I define Insert Array Size below 1 job is getting aborted.
Thanks in Advance
Posted: Wed Sep 10, 2008 7:33 am
by chulett
Array Size != Transaction Size.
Posted: Fri Sep 12, 2008 7:12 am
by snt_ds
Can any please let me know how to commit all transaction at once in Sql Server.
any Environment variable.
Thanks in Advance
Posted: Tue Sep 16, 2008 7:57 pm
by snt_ds
Hello Every one,
Is there any Environment variable to commit all records at once (Single Commit) in SQL SERVER.
I have gone through the documentation but I could n't find any information regarding the single commit.
Can any one please let me know how to do single commit on sql server.
Thanks in Advance