none
Copy Activity from on Premise SQL to Azure Data Lake Store is failing RRS feed

  • Question

  • Hi,

    We are trying to copy the data from on premise SQL to ADLS and it is failing with the below error. Researching from yesterday with no luck, Any insight or guidance please?

    Copy activity encountered a user error: Integration Runtime (Self-hosted) Node Name=GatewayServer,'Type=Newtonsoft.Json.JsonReaderException,Message=Unexpected character encountered while parsing value: <. Path '', line 0, position 0.,Source=Newtonsoft.Json,'.

    Friday, September 29, 2017 2:30 PM

All replies

  • Could you share how you configured the input and output datasets, the activity, and the activity run id of the failed execution?
    Friday, September 29, 2017 2:56 PM
    Moderator
  • {
        "name": "DS_ADLS_Test",
        "properties": {
            "published": false,
            "type": "AzureDataLakeStore",
            "linkedServiceName": "LS_ADLS_DataIngestion",
            "typeProperties": {
                "fileName": "Test.txt",
                "folderPath": "Raw/Consumer/Hub/Test"
            },
            "availability": {
                "frequency": "Hour",
                "interval": 1,
                "style": "StartOfInterval"
            }
        }
    }

    ----------------------------------------------------

    {
        "name": "DS_SQL_MemberContract",
        "properties": {
            "published": false,
            "type": "SqlServerTable",
            "linkedServiceName": "LS_SQL_ConsumerDataHub",
            "typeProperties": {
                "tableName": "dbo.Table1"
            },
            "availability": {
                "frequency": "Hour",
                "interval": 1
            },
            "external": true,
            "policy": {}
        }
    }

    -----------------------------------------------

    Friday, September 29, 2017 3:47 PM