The below command will replace the null value with text UNKNOWN. While extracting rows from excel the empty rows will also be considered and to avoid package error it is advised to use derived column with the following command:
ISNULL(Hardware) ? "UNKNOWN" : Hardware
Also Refer http://sqlblog.com/blogs/andy_leonard/archive/2009/02/04/ssis-expression-language-and-the-derived-column-transformation.aspx
No comments:
Post a Comment