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:

Error at Data Flow Task [SQL Server Destination [14]]: The column “StartDate” can’t be inserted because the conversion between types DT_DATE and DT_DBTIMESTAMP is not supported.

Cause:

I am using SQL Server Destination which do not allow cast of the data type  or implicit cast which cause problem.

Solution:

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.