recover the number of files processed by a Foreach loop

  • Hello everyone
    Who has an idea please how can I get the number of files processed by a loop foreach
    I created a variable and I want to store this number in this variable
    in fact I need this information to insert it into the database
    thank you

  • can you post what you have done so far

    ***The first step is always the hardest *******

  • joujousagem2006 1602 - Monday, July 16, 2018 2:21 AM

    Hello everyone
    Who has an idea please how can I get the number of files processed by a loop foreach
    I created a variable and I want to store this number in this variable
    in fact I need this information to insert it into the database
    thank you

    Set the default value of your variable to be 0.
    Add an expression task within the FEL to increment the value of the variable by 1.
    Perform your DB insert after the FEL, using the variable's value.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • you can help me please more
    in fact I made this

  • Not quite right. See this:

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply