SSIS – How to create a new line character (CRLF) column as Derived Column

By | January 26, 2017

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

Leave a Reply

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