How to insert values into SQL database with ExecuteQuery

[nilesh.mahajan]

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

[hasib08 (Motiwala Hasib)]

Can you show the Insert query

Thanks
@nilesh.mahajan

[nilesh.mahajan]

Below is my SQL Query -

[swridings (Scott Ridings)]

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.

[nilesh.mahajan]

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

[swridings (Scott Ridings)]

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.