varigence / BimlPit

Public Issue Tracker for all Varigence Biml products
6 stars 0 forks source link

RetainSameConnection not being tracked in OleDbConnections #96

Closed jalley3 closed 5 years ago

jalley3 commented 5 years ago

I'm submitting a...


[ ] Regression (a behavior that used to work and stopped working in a new release)
[ ] Bug report  
[ ] Performance issue
[ ] Feature request
[ ] Documentation issue or request
[ ] Support request => Please do not submit support request here, instead go to https://varigence.com/Forums?forumName=Biml or email support@varigence.com
[ ] Other... Please describe:

Current behavior

When specifying the RetainSameConnectionProperty as true, it still emits as false in the generated dtsx.

Minimal reproduction of the problem with instructions

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
<Connections>
  <OleDbConnection Name="UDM" RetainSameConnection="true" ConnectionString="Data Source=Server1;Initial Catalog=Catalog;Provider=SQLNCLI11.1;Integrated Security=SSPI;"></OleDbConnection>
</Connections>
<Packages>
  <Package Name="Test" ConstraintMode="Linear" ProtectionLevel="DontSaveSensitive">
    <Connections>
      <Connection ConnectionName="UDM"></Connection>
    </Connections>
  </Package>
</Packages>        
</Biml>

What is the motivation / use case for changing the behavior?

Environment


BimlExpress version: 5.0.63501.0


Visual Studio Version:

- [ ] 2005
- [ ] 2008
- [ ] 2010
- [ ] 2012
- [ ] 2013
- [ ] 2015
- [x ] 2017

Target SSIS Version:

- [ ] 2005
- [ ] 2008
- [ ] 2008 R2
- [] 2012
- [ ] 2014
- [ ] 2016
- [x ] 2017 (verified in 2017)

Others:


DocGitHub commented 5 years ago

Any updates on this ?

jalley3 commented 5 years ago

The fix for this issue is in place and it will be included in the next release. Thank you for your patience.

In the meantime there is a workaround you can use:

<Package Name="Test" ConstraintMode="Linear" ProtectionLevel="DontSaveSensitive">
    <Connections>
      <Connection ConnectionName="UDM" RetainSameConnection="True"></Connection>
    </Connections>
  </Package>

If you set the property on the connection reference, like above, it will persist in the generated dtsx file.