We built a transformation that pulls data from a web service in small sections (e.g. 10 rows at a time) where the limit is specified by the client.
We then insert those rows into a database using the table output.
We want to commit only when each section of data is finished.
Additionlly, we need to call another webservice when the section is complete to let the server know that the insert was successful. I used an Add Sequence step with the same max value as the commit size to do this (see attached transformation). So this means, we'd also like the Add Sequence to allow Max Value to be a variable too unless there is a better way to do this.