Data flow with a row count that is stored in a variable, add a conditional split that identifies the footer record and stores the count value in another variable

Then return...