Azure Data Factory CSV with double quotes

I got this to work using Escape character set as quote (") with the Azure Data Factory Copy Task. Screen shot:

This was based on a file as per your spec:

"","""Spring Sale"" this year",""

and also worked as in insert into an Azure SQL Database table. The sample JSON:

{    "name": "DelimitedText1",    "properties": {        "linkedServiceName": {            "referenceName": "linkedService2",            "type": "LinkedServiceReference"        },        "type": "DelimitedText",        "typeProperties": {            "location": {                "type": "AzureBlobStorageLocation",                "fileName": "quotes.txt",                "container": "someContainer"            },            "columnDelimiter": ",",            "escapeChar": "\"",            "quoteChar": "\""        },        "schema": [            {                "name": "Prop_0",                "type": "String"            },            {                "name": "Prop_1",                "type": "String"            },            {                "name": "Prop_2",                "type": "String"            }        ]    }}

Maybe the example file is too simple but it did work for me in this configuration.

Alternately, just use SSIS and host it in Data Factory.