Inside a fooreachloop I've got the next configuration in my ssis package:
As you can see, from my source I've got some rows with some problems. With the data viewer I can see them. In theory the flat file destination should record this values on the file indicated by the connector. But instead of that in the destination file I can only see the header and not the values.
From the Staging DB destination the errors are configured with the option of "Redirect Rows"
So, what can be missing in the configuration?
The flat file destination is probably set to truncate, not append. so the lack of data at the end of the loop is probably an indication that the last file succeed with no issues.
If you notice your data viewer is paused, which means that those rows have not yet been flushed to the destination file, so both at the end of execution, and at the precise location the screenshot was taken, i'd expect the file to be empty.
The flat file connection has a "Overwrite data in the file" option to change this behavior, but you many need to manually truncate the file before the first loop other wise you get yesterdays and todays errors in the one file..