Issue (\n ,|,\)while copying data from blob to Azure SQL database using Copy Activity in ADF RRS feed

  • Question

  • Hi Team,

    I am copying data from on-premises DB---->Blob Storage----->Azure SQL DB. I am able to load the data but table contains \n,|,\ in Target database(Azure SQL DB) as shown below screenshot.

    My blob file contains the same records and able to load the data into Azure SQL DB but when loads the data into Azure SQL DB i wanted to remove it \n,\,| which i am unable to remove.Anyone, Could you please help me?

    I am looking forward your response.Thanks!

    Wednesday, January 29, 2020 3:16 AM


All replies

  • Hi Team,

    Could you please help me here?Thanks!

    Wednesday, January 29, 2020 12:05 PM
  • The right activity for ETL work is dataflow not copy.
    Thursday, January 30, 2020 3:43 AM
  • Hi Team,

    I am getting data as expected by using Store procedure activity in Azure data factory.


    Thursday, January 30, 2020 9:26 AM