"[Execute SQL Task] Error: Executing the query "{some SP Name}" failed with the following error: "Procedure or function '{Some SP Name}' expects parameter '{Some Param}', which was not supplied.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. "
Here are 2 REALLY BASIC Checks you can do...
1. Make sure you have the ? in your query...
e.g. exec Some_SP ?
2. It could be that your parameter names are wrong...
The parameter names that you use depend on the connection type that the Execute SQL task uses.
Connection type Parameter name
ADO
Param1, Param2, …
ADO.NET and SQLMOBILE
@
ODBC
1, 2, 3, …
EXCEL and OLE DB
0, 1, 2, 3, …
check out TechNet for some more info.
No comments:
Post a Comment