NULL Date via Expression

  • 94Views
  • Last Post 13 November 2019
  • Topic Is Solved
0
votes
Business Ops posted this 12 November 2019

Hello,

I need to update a salesforce date field with null.  I tried this expression....

NULL(DT_DATE)

...but get this error:

Unexpected token: ' DT_DATE' (start: 5, end: 12)

It's my understanding Skyvia expression syntax is based on SSIS expression syntax.  SSIS documentation - https://docs.microsoft.com/en-us/sql/integration-services/expressions/null-ssis-expression?view=sql-server-ver15 - specifies usage of NULL(DT_DATE) as a valid example, so unsure why it's failing. 

 

Thank you.

Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 13 November 2019

Hello!

 

You are right and the expression is correct.

 

This expression works, it's just Skyvia validator that does not accept values without a column name.

Just save the task with this expression and run your package to check this.

 

Best regards,

Mariia

0
votes
Business Ops posted this 13 November 2019

Thank you!  This worked.

Close