BIML "Date" data type mapped to DT_DATE in FlatFileFormat

When a <Column> under a <FlatFileFormat> has its attribute DataType set to "Date", BIML express emits a DT_DATE column instead of a DT_DBDATE column.

As explained in https://docs.microsoft.com/es-es/sql/integration-services/data-flow/integration-services-data-types?view=sql-server-ver15 :

- DT_DATE : A date structure that consists of year, month, day, hour, minute, seconds, and fractional seconds.
- DT_DBDATE: A date structure that consists of year, month, and day.

According to the previous definition a BIML Date data type should be mapped to a DT_DBDATE. 

0

Comments

0 comments

Please sign in to leave a comment.