Copy data step error copying data from date to date fields

Question

After importing data to a staging table, I am attempting to just append it to a fact table.&nbsp; The process is a simple append from table to table with a partition of DateKey.&nbsp; The tables share the same schema.&nbsp;&nbsp;Mapping:&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;{&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "source": {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "name": "DateKey",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "type": "Date"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "sink": {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "name": "DateKey",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "physicalType": "date"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp;&nbsp;No matter what I do - I get a type conversion error&nbsp;TypeConversionFailure,Exception occurred when converting value '01/05/2024 00:00:00' for column name 'DateKey' from type 'Date' (precision:, scale:) to type 'String' (precision:, scale:). Additional info: Specified cast is not valid.",&nbsp;&nbsp;Not certain why it is casting to string.&nbsp;&nbsp;

v-cboorla-msft · Answer

Hi&nbsp;WilliamBrown&nbsp;
&nbsp;
Apologies for the inconvenience.
Please reach out to our support team to gain deeper insights and explore potential solutions. It's highly recommended that you reach out to our support team. Their expertise will be invaluable in suggesting the most appropriate approach.
Please go ahead and raise a support ticket to reach our support team:
https://support.fabric.microsoft.com/support
After creating a Support ticket please provide the ticket number as it would help us to track for more information.
&nbsp;
Thank you.

v-cboorla-msft · Answer

Hi&nbsp;WilliamBrown&nbsp;
&nbsp;
We haven’t heard from you on the last response and was just checking back to see if you've had a chance to submit a support ticket. If you have, a reference to the ticket number would be greatly appreciated. This will allow us to track the progress of your request and ensure you receive the most efficient support possible.
&nbsp;
Thank you.

williambrown · Answer

Sorry, was off a bit and side tracked.&nbsp; Will do today

williambrown · Answer

Just wanted to let people know the resolution.&nbsp; I landed the data into a table with datekey set to text, then appended the data to the permanent table, and converted it to Date Format in the destination table.&nbsp;&nbsp;

Forum Discussion

Copy data step error copying data from date to date fields

4 Replies

Related content

Copy activity error

DataFlow Gen 2 Error:Fast copy user error

Copy Job source internal error

Copy Job Actitivity Error

error with copy data activity