Azure Data Factory V2 - Calling a stored procedure with an output parameter RRS feed

  • Question

  • I want to create an ADF v2 pipeline that calls a stored procedure in Azure SQL Data Warehouse. The stored procedure has two parameters, one of which is an output parameter. The stored procedure loads a staging table. The number of records loaded into the staging table is then assigned to the output parameter.

    Is there a way to use the value of the output parameter later in my pipeline?

    In SSIS I would have used a row count transform to assign the value into a parameter and then access that parameter later on in the same package.

    Friday, October 27, 2017 4:17 AM