Pass a variable through the SSIS Package, but needs to loop the value of the variable to run the Stored Procedure. RRS feed

  • Question

  • Hi,

    I have a Project Where a Stored Procedure needs to run inside the SSIS Package to create a File. In this process, the value of the Parameter needs to change and run the stored procedure multiple times to generate a different set of files. I know that this could be accomplished through For-Each Loop Container. But I do not know the steps to achieve this. Somebody suggested For Each Variable Enumerator. If anyone has clues how to do this, please let me know.



    Monday, October 2, 2017 4:57 PM

All replies