tengo un problema con la actividad de copia para convertir una cadena a la fecha usando un mapeo personalizado ADF

Servicio Azure 0 Reputation points

Estoy intentando realizar una conversión de un campo tipo STRING, donde llega una fecha con formato 20230327, esto necesito tenerlo de la manera 2023-03-27 es decir YYYY-MM-DD, lo estoy haciendo desde el JSON, pero no me funciona, no me sale error pero no me hace el cambio tampoco, ayudaa!!,

                                "source": {
                                    "name": "BUDAT",
                                    "type": "Datetime",
                                    "physicalType": "D",
                                    "format": "YYYY-MM-DD"
                                "sink": {
                                    "name": "BUDAT",
                                    "type": "String",
                                    "physicalType": "nvarchar"
                        "typeConversion": true,
                        "typeConversionSettings": {
                            "allowDataTruncation": true,
                            "treatBooleanAsNumber": false,
                            "dateTimeFormat": "yyyyMMdd"
SAP HANA on Azure Large Instances
SAP HANA on Azure Large Instances
Microsoft branding terminology for an Azure offer to run HANA instances on SAP HANA hardware deployed in Large Instance stamps in different Azure regions.
109 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,000 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ShaikMaheer-MSFT 34,536 Reputation points Microsoft Employee

    Hi Servicio Azure,

    Thank you for posting query in Microsoft Q&A Platform.

    It would be great if you can share details in English to help better.

    If you are looking for converting date format using dataflows in Azure data factory, then toDate() function will works. If you are not using dataflows, then kindly share more details about activity implementations along with configurations screen to understand issue better and help by repro same at my end. Thank you.