none
How to pass @trigger().scheduledTime as parameter for stored procedure through adfv2

    Question

  • I want to pass the @trigger().scheduledTime as parameter for stored procedure to get the trigger scheduled time. But when I pass @trigger().scheduledTime as parameter, I'm getting "Activity SP_RecordSplit failed: 'The template language expression 'trigger().scheduledTime' cannot be evaluated because property 'scheduledTime' doesn't exist, available properties are 'name, outputs, startTime, endTime, trackingId, clientTrackingId, status'." error.

    I'm able pass @trigger().startTime as parameter.

    Could you please advise me what will be issue here ?

    typeProperties": {
    "storedProcedureName": "[dbo].[SP_RecordSplit]",
    "storedProcedureParameters": {
    "slicetime": {
    "value": {
    "value": "@trigger().scheduledTime",
    "type": "Expression"
    },
    "type": "Date"
    }
    }
    },

    Thanks

    Tuesday, September 11, 2018 5:39 PM

All replies

  • Hi, 

    You need to define a pipeline parameter and refer it as the storedprocedure parameter, then pass "@trigger().scheduledTime" to the pipeline parameter when trigger the pipeline run. This link give you more information.

    Thanks.


    Wednesday, September 12, 2018 5:31 AM