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 12 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’s mind leveraging geographically dispersed team members.

Leave a Reply

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