can anyone please provide a working example of an execute non-query activity which uses parameters ? that is,
I am trying to use @ParameterName in my query. However, the query is not being substitued for the values as defined in my parameter list. What am I doing wrong ?
my query is something like update table Set fieldname=@ParameterName where fieldname=@parameterx
I am sure that the parameter has the correct value (used Log Message to check that).
The SQL statement which is being sent to the db does NOT substitue the @parameterName with the value.
help is much appreciated !!