Error: Conversion between types DT_DATE and DT_DBTIMESTAMP is not supported in SSIS
While using Excel source to SQL Server Destination in DATA FLOW tab facing error.
Error at Data Flow Task [SQL Server Destination ]: The column “StartDate” can’t be inserted because the conversion between types DT_DATE and DT_DBTIMESTAMP is not supported.
I am using SQL Server Destination which do not allow cast of the data type or implicit cast which cause problem.
Replace data flow task from SQL SERVER Destination with an OLE DB destination. SQL Server destinations are type-specific and do not allow implicit casts. May we can also try with Data Conversion Task in between Excel source and SQL Server Destination.