Is there any way to keep a running count of a number using a local/global variable within the ProcessInputRow function in a SSIS Component Script?
for example:
Row1: 1
Row2: 1
Row3: 0
So say the variable is set default = 0
After row 1, the variable will now be = 1
After row 2, the variable will now be = 2
After row 3, the variable will now be = 1
Since the ProcessInputRow function processes each input row individually, it resets my local variables, and you can't use SSIS user created variables outside of PostExecute(), I am at a loss here.
Let me know if this answers your question