Sql server Commit

snt_ds · Post by **snt_ds** » Mon Aug 25, 2008 8:45 am

In sqlserver target, how to commit records all at once (single commit)

Thanks in Advance

ray.wurlod · Post by **ray.wurlod** » Mon Aug 25, 2008 3:45 pm

What stage type are you using? Usually this is by setting transaction size to 0 (which means "all rows are one transaction").

snt_ds · Post by **snt_ds** » Thu Sep 04, 2008 8:20 am

We are using SqlServer Enterprise stage.
so please let me know what options to use and where?

ray.wurlod · Post by **ray.wurlod** » Thu Sep 04, 2008 3:31 pm

An environment variable governs transaction size. A search will find its name for you.

snt_ds · Post by **snt_ds** » Wed Sep 10, 2008 6:25 am

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

chulett · Post by **chulett** » Wed Sep 10, 2008 7:33 am

Array Size != Transaction Size.

snt_ds · Post by **snt_ds** » Fri Sep 12, 2008 7:12 am

Can any please let me know how to commit all transaction at once in Sql Server.

any Environment variable.

Thanks in Advance

snt_ds · Post by **snt_ds** » Tue Sep 16, 2008 7:57 pm

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