recover the number of files processed by a Foreach loop

Question

Post reply

recover the number of files processed by a Foreach loop

joujousagem2006 1602

SSCommitted

Points: 1779
More actions
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

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

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

SGT_squeequal SSCertifiable Points: 7167 More actions · Answer 1

can you post what you have done so far

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

Phil Parkin SSC Guru Points: 247109 More actions · Answer 2

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.