Transaction Size in MSOLEDB stage

[LogicDude]

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.