Execute SQL Task error -
- by sharadov
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.