Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

0

TypeConversionFailure when not trying to convert

Running a Copy Data node inside a Data Pipeline, we get the following error message:

 

ErrorCode=TypeConversionFailure,Exception occurred when converting value '16.12.1985' for column name '33_ColumnName' from type 'String' (precision:, scale:) to type 'Date' (precision:, scale:). Additional info: String was not recognized as a valid DateTime.

 

However, we are not asking for a converision:

logan_l_0-1713773147663.png

What went wrong?

 

Thanks.

Status: Delivered

Hi @logan_l ,

 

Thank you for sharing, for other users with similar experiences you can check the comments below. This thread will now be closed.

 

Best regards.
Community Support Team_ Caitlyn

Comments
logan_l
New Member

The problem was that the destination already contained rows, and so datatypes had been set. In the Destination tab, under Advanced, I changed Table action to Overwrite.

v-xiaoyan-msft
Community Support
Status changed to: Delivered

Hi @logan_l ,

 

Thank you for sharing, for other users with similar experiences you can check the comments below. This thread will now be closed.

 

Best regards.
Community Support Team_ Caitlyn