如何通过adfv2将@trigger().scheduledTime作为存储过程的参数传递 [英] How to pass @trigger().scheduledTime as parameter for stored procedure through adfv2

问题描述

@ trigger().scheduledTime作为参数 用于存储过程以获取触发器的计划时间.但是当我通过 SP_RecordSplit

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.

@ trigger().startTime作为参数.

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

typeProperties":{

推荐答案

Hi, 

您需要定义管道参数并将其引用为storedprocedure参数，然后 @ trigger().scheduledTime 添加到管道参数.

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.

谢谢.

这篇关于如何通过adfv2将@trigger().scheduledTime作为存储过程的参数传递的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！