多个复制参数传递给单个存储过程? [英] Multiple Copy parameters passing to single stored procedure?

问题描述

i有一个带有传递表名参数的存储过程，它将删除重复的行.完成每个复制组件后，我将调用此存储过程.

i have a stored procedure with passing table name parameter it will delete the duplicate rows. i am calling this stored procedure after completion of every copy component.

不是为每个复制组件创建单独的存储过程，而是是否可以通过传递如下所示的不同复制参数来仅创建一个存储过程?如果可能，如何将复制表名参数传递给单个存储过程?

Instead of creating individual stored procedure for every copy component,  is it possible to create just one stored procedure by passing the different copy parameters as below? if possible, how to pass the copy tablename parameter to single stored procedure?

推荐答案

Foreach活动可以满足您创建一个存储过程的要求.您需要构造一个"tableNames"数组.作为Foreach活动中的迭代项，然后在其中包含一个Copy活动和一个Stored Procedure活动. 对于foreach活动，请使用"item()"；引用数组中的tableName并将其传递给

The Foreach activity may achieve your requirement to create just one Stored procedure. You need to construct anarray of the "tableNames" as the iterated items in Foreach activity, and then involve a Copy activity and a Stored procedure activity in the foreach activity, use "item()" to refer the tableName in array and pass it to Stored procedure activity.

请参见下面的屏幕截图:

See the screen shot below:

谢谢.

这篇关于多个复制参数传递给单个存储过程?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！