You are viewing limited content. For full access, please sign in.

Question

Question

WF: Update SQL Table

Workflow
Updated September 19, 2014
asked on September 18, 2014

I need to update a SQL table where one column is equal to a template field and the other column is NULL.

I have been able to store the value of the template field, but am running into issues when using the update data tool in workflow. I get the following error:

ERROR [22007] [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting date and/or time from character string.

I am assuming I setup the tool wrong and the update data is looking for a column that has the text "NULL" as a value rather than an empty value.

 

How should I setup the Update Data tool or should I be using a different tool in my workflow?

 

 

 

0 0

Replies

replied on September 19, 2014

To look for or assign a column to have NULL as the value, use the following token syntax:

%(DB.NULL)

 

If you are using tokens to fill the activity for what to look for or what to update, you may need to enable the tokens when you make them to be of that type. By default, tokens are strings. It seems like you need to format your date into a string though, so you might wanna review the formatting of the table to make sure you have things set up properly the way the database table is storing data.

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...