ITPub博客

首页 > Linux操作系统 > Linux操作系统 > SSIS display null in destination file

SSIS display null in destination file

原创 Linux操作系统 作者:keeking 时间:2012-06-12 21:21:25 0 删除 编辑
I suggest you can use string "Null" instead of "NULL" using Derived Column Transformation, and then load the data to Excel Destination.  Please refer to the steps about configuring the Derived Column Transformation as below:


1. Open the Derived Column Transformation Editor, Select "Replace ColumnName" in the "Derived Column".
2. Write expression "ISNULL(ColumnName) ? "Null" : ColumnName" in the "Expression".  

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7899089/viewspace-732608/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-07-23

  • 博文量
    194
  • 访问量
    239212