SSIS display null in destination file

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/，如需轉載，請註明出處，否則將追究法律責任。