How to insert values into SQL database with ExecuteQuery

I am trying to store the values into SQL database with Execute non Query, but getting the below error. can anyone please help to solve this.


Parameters -

Below is the SQL table Columns


Can you show the Insert query


Below is my SQL Query -

Can you insert a WriteLine activity to see what value is being passed to @DESCRIPTION.

You will have a problem if it is a NULL value.

Yes sometimes Description will be blank, So is there is any blank column that will not updated?
or is there any solution on that

You could insert an IF statement. The condition would be:

String.IsNullOrEmpty(descriptionVariableHere) = True

If it is true you can use an Assign activity to assign a value of “None” or “NA”.

That way you will always have a value to put in the parameter.