I have a column in a data flow task which contains carriage return/line breaks. Is it possible to remove them with a derived column - or is there a better way to do this?
thanks in advance
Yeah, it should be possible. Use the REPLACE function. "\r\n" indicates a CRLF
No comments:
Post a Comment