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

Vishal Monpara is a full stack Solution Developer/Architect with 13 years of experience primarily using Microsoft stack. He is currently working in Retail industry and moving 1’s and 0’s from geographically dispersed hard disks to geographically dispersed user leveraging geographically dispersed team members.

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

  1. 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”,” “)))

Leave a Reply

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