How did you add the | to the individual records? If that is easily removable you might try adding a Derived Column Transform and add a new column named (literally) | and make the expression "|".
This will add a column named | with a value of "|" to your data flow - just make sure it is the last column and you should be ok.
I am curious though, why do you need a column delimiter at the end of your record when there are no more columns in the record?
Thanks - hope this helped!
I added the pipe in the sql script like this below:
ADDRESS_MASTER.ADDR_LINE_1 + '|' AS 'email'
The vendor that is requesting this file would like a pipe delimiter at the end to close out that row of data.