Need to pass dynamic file names in a loop to a stored procedure task in azure data factory


  • Hi Team, 

    I'm doing a bulk insert in a stored procedure where filenames are input parameters for the procedure. How can i pass these dynamic filenames in parameters of stored procedure task. 

    As shown in the above screenshot, need to pass a dynamic filename as a parameter.  



    Thursday, September 27, 2018 4:24 AM

All replies

  • Hi,

    You can click the "Add Dynamic Content" link below the value textbox, and add your dynamic filename as parameter in the side drawer.

    Thursday, September 27, 2018 5:20 AM