Dynamically disable container transaction

Good morning, I want to know if there is a way to dynamically disable or change the TransactionMode of a Container. With BimlExpress Build 5.0.60425.0 and lower we was able to set the SSIS TransactionOption property via Expression (see https://varigence.com/Forums?threadID=9847). All most recent builds does not recognize anymore the values for the SSIS TransactionOption property, as you can see in my previous thread. Can you fix this regression or explain me how to reach the same goal with newer versions of BimlExpress? Unitl this error persists, I cannot update BimlExpress on my Visual Studio. Thank you.

0

Comments

4 comments
  • Thank you for bringing this to our attention. I have confirmed that I am able to reproduce the issue, and I have filed a bug for you here: https://github.com/varigence/BimlPit/issues/93 ...please subscribe to follow along for updates as we progress and fix the issue.

    0
    Comment actions Permalink
  • Thank you, Jacob! I've subscribed myself to the GitHub thread, so I'm following the updates of the issue.
    0
    Comment actions Permalink
  • I did not see you subscribed, but I just closed the issue as we have found a solution. We will get you a build in the next few days that contains this fix. However in the meantime i believe you should be able to use this workaround:

    <Expression ExternalProperty="TransactionOption">
      <![CDATA[@[$Project::TransactionEnabled]  ? 2 : 0]]>
    </Expression>

    Sorry that we did not get this work around to you sooner.

    0
    Comment actions Permalink
  • Good morging Jacob, with the work around you suggested I'm able to compile my projects. Thank you.
    0
    Comment actions Permalink

Please sign in to leave a comment.