Is there a way to Update a SQL field as a NULL value?

Comments

2 comments

  • Avatar
    Vinutha C

    Hi Gwen,

    To update record with NULL value you can use "UpdateProcessData" activity. In "UpdateProcessData" activity > Process Data variable , type the word "NullValue" and in Expression, type "System.DBNull.Value". In your "Update Record" activity assign the variable ${NullValue} for the column you wanted to update NULL value.

    Please refer below screenshots for more info.

     

    Thanks.

    2
    Comment actions Permalink
  • Avatar
    Gwen Wilson

    Thank you! This worked perfectly.

    0
    Comment actions Permalink

Please sign in to leave a comment.