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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
WilliamBrown
Frequent Visitor

Copy data step error copying data from date to date fields

After importing data to a staging table, I am attempting to just append it to a fact table.  The process is a simple append from table to table with a partition of DateKey.  The tables share the same schema.  

Mapping:  

               {
                    "source": {
                        "name": "DateKey",
                        "type": "Date"
                    },
                    "sink": {
                        "name": "DateKey",
                        "physicalType": "date"
                    }
                }
 
 
No matter what I do - I get a type conversion error 

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.",  

Not certain why it is casting to string.  
4 REPLIES 4
WilliamBrown
Frequent Visitor

Just wanted to let people know the resolution.  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.  

WilliamBrown
Frequent Visitor

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

v-cboorla-msft
Community Support
Community Support

Hi @WilliamBrown 

 

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.

 

Thank you.

Hi @WilliamBrown 

 

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.

 

Thank you.

Helpful resources

Announcements
Oct Fabric Update Carousel

Fabric Monthly Update - October 2024

Check out the October 2024 Fabric update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.