Home Forums SQL Server 2005 SQL Server 2005 Integration Services Remove Null value from dt_ntext field RE: Remove Null value from dt_ntext field

  • June 13, 2016 at 5:26 am

    #1884607

    I got the same error.

    Here is the conversion :

    (ISNULL(Mobile)?"": (DT_WSTR,1024)Mobile) != (ISNULL([Dest_Mobile] )?"": (DT_WSTR,1024) [Dest_Mobile] )

    Below article is nice for reference

    http://sqlblog.com/blogs/andy_leonard/archive/2009/02/04/ssis-expression-language-and-the-derived-column-transformation.aspx