-
Input parameter issue in SSIS
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|