Passing triggerID to the destination column

  • ammit.it2006

    Ten Centuries

    Points: 1233

    Hi

    I am trying to load the data from the on-premise sql server to Sql Server at VM. I need to do it every day. For the same, I have created a trigger. Trigger is inserting the data properly. But now, I need to insert triggerID in the destination columns for every run in a column.

    I was trying to insert the value of the same like this but it's giving error.

    "Activity Copy Data1 failed: Please choose only one of the three property "name", "path" and "ordinal" to reference columns for "source" and "sink" under "mappings" property. "

    pipeline details. Please suggest

    {

    "name": "pipeline1",

    "properties": {

    "activities": [

    {

    "name": "Copy Data1",

    "type": "Copy",

    "dependsOn": [],

    "policy": {

    "timeout": "7.00:00:00",

    "retry": 0,

    "retryIntervalInSeconds": 30,

    "secureOutput": false,

    "secureInput": false

    },

    "userProperties": [],

    "typeProperties": {

    "source": {

    "type": "AzureSqlSource"

    },

    "sink": {

    "type": "SqlServerSink"

    },

    "enableStaging": false,

    "translator": {

    "type": "TabularTranslator",

    "mappings": [

    {

    "source": {

    "name": "Name",

    "type": "String"

    },

    "sink": {

    "name": "Name",

    "type": "String"

    }

    },

    {

    "source": {

    "type": "String",

    "name": "@pipeline().parameters.triggerIDVal"

    },

    "sink": {

    "name": "TriggerID",

    "type": "String"

    }

    }

    ]

    }

    },

    "inputs": [

    {

    "referenceName": "AzureSqlTable1",

    "type": "DatasetReference"

    }

    ],

    "outputs": [

    {

    "referenceName": "SqlServerSQLDEV02",

    "type": "DatasetReference"

    }

    ]

    }

    ],

    "parameters": {

    "triggerIDVal": {

    "type": "string"

    }

    },

    "annotations": []

    }

    }

  • Site Owners

    SSC Guru

    Points: 80380

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply