I have a SSIS Package which fails to transfer data to the destination database table.
The error I am getting is;
[SQL Server Destination ] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E07. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E07 Description: "Error converting data type DBTYPE_DBTIMESTAMP to datetime.".
The datatype in some of the database table columns is datetime and I have converted some columns of the source data to DBTYPE_DBTIMESTAMP, which I assume is compatible with datetime…
Any help appreciated, thanks