I have a dtsx with a Flat File Source that apparently can load data such
such as "03-Apr-1990" as a DT_DBDATE ...

( I say apparently because if I specify this col should be DT_DBDATE there
is no error listed in the Flat File Source )

But if I build a Data Flow Task that maps this DT_DBDATE col to a SQL Server
DateTime col, the dtsx fails with error

TITLE: Package Validation Error
------------------------------

Package Validation Error

------------------------------
ADDITIONAL INFORMATION:

Error at Data Flow Task [OLE DB Destination [225]]: The OLE DB provider used
by the OLE DB adapter cannot convert between types "DT_DBDATE" and "DT_I8"
for "DateTime".

Error at Data Flow Task [DTS.Pipeline]: "component "OLE DB Destination"
(225)" failed validation and returned validation status "VS_ISBROKEN".

Error at Data Flow Task [DTS.Pipeline]: One or more component failed
validation.

Error at Data Flow Task: There were errors during task validation.

(Microsoft.DataTransformationServices.VsIntegration)

------------------------------
BUTTONS:

OK
------------------------------