Transaction Size in MSOLEDB stage
Posted: Tue Oct 11, 2005 1:12 pm
Hi,
I am using MSOLEDB stage to load into the SQL Server database. In OCI Stage, we select transaction size as "0" if we want to committ at the end. But what should I do for MSOLEDB Stage? It does not accept "0" value for transaction size and array size.
It accepts values between 1 and 99999. (In OCI, it's between 0 and 99999. Why is this difference? I am not well versed with SQL server. I am looking forward to understand how the 'committ' is diffrent from oracle.)
Earlier I was using a value of "100" for both of them but now I want to committ at the end.
TIA.
I am using MSOLEDB stage to load into the SQL Server database. In OCI Stage, we select transaction size as "0" if we want to committ at the end. But what should I do for MSOLEDB Stage? It does not accept "0" value for transaction size and array size.
It accepts values between 1 and 99999. (In OCI, it's between 0 and 99999. Why is this difference? I am not well versed with SQL server. I am looking forward to understand how the 'committ' is diffrent from oracle.)
Earlier I was using a value of "100" for both of them but now I want to committ at the end.
TIA.