• sdevanny (7/17/2013)


    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.

    Thanks!