locked
Copy activity - Consider blank values in CSV as NULLs RRS feed

  • Question

  • I have a CSV file with double quotes as qualifiers. In Azure Data Factory, when I use the Copy Activity to copy the file from Blob storage to Azure SQL Database, the blank values show up as blanks and not NULL values. Is there anything I can do convert the blanks ("") to NULLs in my ADF pipeline?

    The CSV file looks something like the following:

    "115610","","","","","","","","","","","NEW","0.0000","","","","","0.0000"
    "115673","","","","","","","","","","","NEW","0.0000","","","","","0.0000"

    In my Azure Data Factory CSV Dataset, I have set Null Value to "" but that doesn't convert them to NULLs. I have tried leaving the Null Value setting as empty but again, that doesn't help.

    Thanks.

    Monday, October 28, 2019 2:59 AM

All replies