SSIS 用derived column 去除 数据中的换行

 

一下column里存在回车，expression里面代码如下：REPLACE(REPLACE(TRIM(ForumMetadataName),"\r",""),"\n","")