Forum Discussion

msprog's avatar
msprog
Advocate III
11 months ago
Solved

Copy activity dynamic mapping

Hi, we have a data pipleine with  copy activity, we read data from SAP DSP and write to a lakehouse table.  some of the SAP fields are TimeSPan which are not supported by lakehouse, so we enable ex...
Need Help
  • vivien57's avatar
    vivien57
    11 months ago

    Hello msprog ,

    I recommend you follow these steps (they helped me) :

     - Build a manual mapping.
     - Run the pipeline and check that it works.
     - Retrieve the mapping generated in the JSON code.
     - Delete the manual mapping and copy/paste the dynamically generated code into the mapping.


    Does it work now? 

    This allows us to rule out a problem with the automatic generation of JSON code.

    Have a nice day,

    Vivien

vivien57's avatar
vivien57
Super User
11 months ago

Hello msprog ,

I recommend you follow these steps (they helped me) :

 - Build a manual mapping.
 - Run the pipeline and check that it works.
 - Retrieve the mapping generated in the JSON code.
 - Delete the manual mapping and copy/paste the dynamically generated code into the mapping.


Does it work now? 

This allows us to rule out a problem with the automatic generation of JSON code.

Have a nice day,

Vivien