Dynamically disable container transaction

Diego

November 30, 2018 21:56

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.

Comments

4 comments

jacob alley
March 12, 2018 23:56

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
Diego
April 12, 2018 11:00

Thank you, Jacob! I've subscribed myself to the GitHub thread, so I'm following the updates of the issue.

0

Comment actions Permalink
jacob alley
April 12, 2018 20:31
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
Diego
June 12, 2018 13:39

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.