Home Forums SQL Server 2005 SQL Server 2005 Integration Services Nz(FieldName,'') Equivalent in SSIS for Microsoft Jet Ole db provider RE: Nz(FieldName,'') Equivalent in SSIS for Microsoft Jet Ole db provider

  • June 3, 2009 at 7:02 am

    #1003965

    you can use the COALESCE function in SQL server to perform a simliar opertion to Nz

    select coalesce(FieldName,'NewValue')

    http://msdn.microsoft.com/en-us/library/ms190349.aspx