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
Thanks
@nilesh.mahajan
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.
2 Likes