This works fine directly in SSIS, but I am now trying to generate the SSIS package using BIML. Every time I try to generate a package (using BIMLExpress or BIDSHelper in Visual Studio) from BIML which uses a data flow using such a connection I get tan error like...
Node ADO NET Source: COuld not execute Query on Connection MyConnection:
"My Source Query"
Keyword not supported: 'host'
It's like it cannot make a connection using my connection string: "User Id=MyUserName;Password=MyPassword;Host=MyServerName;Database=MyDatabaseName;Persist Security Info=False;Unicode=True;Default FetchAll=true;"
Can anyone help?
Example of the sort of BIML code i'm using:
AdoNetConnection at top level:
Code: Select all
<AdoNetConnection Name="MyConnection"
Provider="Devart.Data.PostgreSql.PgSqlConnection, Devart.Data.PostgreSql, Version=7.4.521.0, Culture=neutral, PublicKeyToken=00MyKey00"
ConnectionString="User Id=MyUserName;Password=MyPassword;Host=MyServerName;Database=MyDatabaseName;Persist Security Info=False;Unicode=True;Default FetchAll=true;"
DelayValidation="true">
</AdoNetConnection>
Code: Select all
<Connections>
<Connection ConnectionName="MyConnection"/>
</Connections>
Code: Select all
<Dataflow Name="Data Flow Task">
<Transformations>
<AdoNetSource Name="ADO NET Source" ConnectionName="MyConnection">
<DirectInput>
SELECT columnA, ColumnB FROM MyTable
</DirectInput>
</AdoNetSource>
<DataReaderDestination Name="DataReaderDest">
<InputPath OutputPathName="ADO NET Source.Output" />
</DataReaderDestination>
</Transformations>
</Dataflow>