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.
- 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.