varigence / BimlPit

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

BimlExpress does not work with Oracle.ManagedAccess driver #107

Open jalley3 opened 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

BimlExpress cannot build packages that contain ado connections that use the Oracle.ManagedAccess driver.

Minimal reproduction of the problem with instructions

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
    <Connections>
        <AdoNetConnection Name="localhost/orcl.SYSTEM" ConnectionString="DATA SOURCE=localhost/orcl;USER ID=SYSTEM;PASSWORD=varigence;" Provider="Oracle.ManagedDataAccess.Client.OracleConnection, Oracle.ManagedDataAccess, Version=4.122.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />
    </Connections>
    <Packages>
        <Package Name="Package" Language="None" ConstraintMode="LinearOnCompletion" ProtectionLevel="DontSaveSensitive">
            <Tasks>
                <Dataflow Name="Data Flow Task">
                    <Transformations>
                        <AdoNetSource Name="ADO NET Source" ConnectionName="localhost/orcl.SYSTEM">
                            <DirectInput>select * from help</DirectInput>
                        </AdoNetSource>
                    </Transformations>
                </Dataflow>
            </Tasks>
        </Package>
    </Packages>
</Biml>