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
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