Knowledge.ToString()

SSIS – How to Create a New Line Character (CRLF) Column as Derived Column

Use the following expression in order to create a derived column

(DT_STR,2,1252)"\r\n"

By default Data Type of string “\r\n” is DT_WSTR so here I am casting the data type to DT_STR

Share

Comments

One response to “SSIS – How to Create a New Line Character (CRLF) Column as Derived Column”

  1. Navin Avatar
    Navin

    Thanks, worked perfectly. I was looking to replace new line characters with ‘ ‘. The below worked.

    LTRIM(RTRIM(REPLACE([Field],(DT_STR,2,1252)”\r\n”,” “)))

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *