Multiple Copy parameters passing to single stored procedure? RRS feed

  • Question

  • 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?


    Monday, September 10, 2018 10:24 AM

All replies

  • Hi,

    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:


    Tuesday, September 11, 2018 2:30 AM