1. Varigence
  2. Community
  3. BimlStudio

Maximim insert commit size

Avatar
David Jarrett
Follow
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
Sort by Date Votes
  • Avatar
    David Jarrett
    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
  • Avatar
    Mark Stellingwerff
    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
  • Avatar
    jacob alley
    This issue has been resolved as of build 5.0.63025.0.
    0
    Comment actions Permalink

Please sign in to leave a comment.