topic Re: Copy data step error copying data from date to date fields in Pipelines

Copy data step error copying data from date to date fields

WilliamBrown — Mon, 24 Jun 2024 17:54:59 GMT

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.

Re: Copy data step error copying data from date to date fields

v-cboorla-msft — Thu, 27 Jun 2024 12:02:36 GMT

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.

Re: Copy data step error copying data from date to date fields

v-cboorla-msft — Mon, 01 Jul 2024 05:38:59 GMT

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.

Re: Copy data step error copying data from date to date fields

WilliamBrown — Tue, 02 Jul 2024 17:35:23 GMT

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

Re: Copy data step error copying data from date to date fields

WilliamBrown — Sun, 14 Jul 2024 23:22:40 GMT

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.