Conversion between types DT_DATE and DT_DBTIMESTAMP is not working with SQL Server Destination in SSIS

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.