如何将活动状态写入参数 [英] How to write the activity status to a parameter

问题描述

除了有关活动(状态，名称，读取的行)的其他一些信息外，我还需要捕获系统变量(管道名称等)，并将其从复制任务传递到存储过程将信息写入表的任务 在Azure SQL数据库中.

I need to capture the system variables (Pipeline Name, etc. ) in addition to some other pieces of information about an activity (Status, Name, Rows Read) and pass it from the Copy task to a Stored Procedure task that will write that information to a table in Azure SQL DB.

除了系统变量之外，您如何访问其他部分(状态，行，活动名称)?如果选择连接复制任务和存储过程的行，则会在输出"列表中看到一个表.带有这些字段的标签，但不确定如何引用

Aside from the System Variables how do you access the other pieces (Status, Rows, Activity Name)?  If I select the line connecting the copy task and stored procedure I see a table on the "output" tab with these fields but not sure how to reference them in the stored procedure or store them into parameters?

推荐答案

您好，要引用存储过程中复制活动的输出，请使用表达式'@activity('复制活动名称').output.fieldname'.

Hi Shannon, to reference output of copy activity in store procedure, please use the expression '@activity('Copy activity name').output.fieldname'.

参考https://docs.microsoft.com/zh-cn/azure/data-factory/copy-activity-overview#monitor-以编程方式查看您可以在其中使用什么

Reference https://docs.microsoft.com/en-us/azure/data-factory/copy-activity-overview#monitor-programmatically to see what fieldnames you can use in copy activity output info.

这篇关于如何将活动状态写入参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！