Hello,
I'm getting the row count in data flow task and storing the result in variable. I'm updating this row count in another table using Execute SQL Task using the below syntax.

declare @rowcount int

SET @rowcount=?

update controltable
set rowcount=@rowcount
where id=(select max(id) from controltable)

I'm getting the below error. I'm using the same process in another server and it is running fine. But it is not running in new server. Is there any issue in SSIS or missing any Software.
I appreciate your suggestion on my issue.

failed with the following error: "Syntax error, permission violation, or other nonspecific error". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.