Post reply

recover the number of files processed by a Foreach loop

  • July 16, 2018 at 2:21 am

    #354687

    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

  • July 16, 2018 at 6:21 am

    #1997640

    can you post what you have done so far

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

  • July 16, 2018 at 7:17 am

    #1997653

    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.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • July 17, 2018 at 4:59 am

    #1997783

    you can help me please more
    in fact I made this

  • July 17, 2018 at 5:24 am

    #1997788

    Not quite right. See this:

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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