Maximim insert commit size

Hi, I've set the "MaximumInsertCommitSize" property to 0 in the BIML file, however the resultant SSIS package has a "Maximum insert commit size" value of 2147483647 which is the default. Does BIML not support setting this value to 0? Thanks
0

Comments

3 comments
  • Doesn't appear to be a resolution. Only work around I have is manually changing it in the generated package, which is undesirable for obvious reasons.
    0
    Comment actions Permalink
  • I have a similar issue. When using MaximumInsertCommitSize = "0" on the OleDbDestination component the result of the Maximum insert commit size property is set to "2147483647" instead of the expected "0". How to work around/resolve this?
    0
    Comment actions Permalink
  • This issue has been resolved as of build 5.0.63025.0.
    0
    Comment actions Permalink

Please sign in to leave a comment.