I'm just getting into BIML. And I have an issue about the Usage of an ODBC-Datasource.
In general the generation of the SSIS-Package is working. The Source is a Postgres-Database. I'm using the Postgres psql-odbc-Driver 13.02. The issue is about the automated creation of the column-Metadata in the ODBC-Source. For example: I have a date-column in the Postgres Table. It doesn't matter if if explicitely cast the column to date or let BIML detect the datatype. The Datatype of the "External Column" (Advanced Editor, SSIS, Visual Studio 2019) is "DT_DBDATE". And the Datatype of the same Column in "Output Columns" is "[DT_DBTIMESTAMP]". As you can see these two don't match. And this is also the Warning I get in Visual Studio "Validation warning [...] The external columns for [...] are out of synchronization with the data source columns. The external column "XXX" needs to be updated.".
So how am I supposed to get in Control of this? How can I manage that the generated SSIS-Package has matching Datatypes in External and Output-Columns. Sure, I could disable validation of Metadata. But this would be like covering the Engine-Warning-Light in your car with a sticker. No real solution.
I have this issue with other datatypes too. The Source-Datatype in Postgres is timestamp. In the OdbcSource it's "DT_DBTIMESTAMP2" for the External Column and "DT_DBTIMESTAMP" in the Output-Column. Also no match which triggers the Visual Studio Warning.
Any advice here would be appreciated.