Execute SQL Task error -

Posted by sharadov on Stack Overflow See other posts from Stack Overflow or by sharadov
Published on 2010-04-15T19:18:28Z Indexed on 2010/04/15 19:23 UTC
Read the original article Hit count: 244

Filed under:
|
|

I get the following error when I call a stored proc within an execute sql task in SSIS. "Description: Executing the query "Exec up_CallXXX" failed with the following error: "Incorrect syntax near '13'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly."

The stored proc runs fine when I execute it through SSMS. Does anyone have an idea what is going on.

© Stack Overflow or respective owner

Related posts about sql

Related posts about server