Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
varalakshmi
Yak Posting Veteran
98 Posts |
 Posted - 2010-07-26 : 08:28:45
|
| Hi,When executing a parameterized stored procedure manually by giving values, the procedure is executed successfully.When triggered throught Execute SQL task of the SSIS, it is throwing error like "Incorrect syntax near the '@parameter'"Here the parameter value is stored in a variable.Please suggest on how this could be solved. What could be the possible reasons for this error?-Varalakshmi. |
|
|
oldjeep
Starting Member
5 Posts |
Posted - 2010-08-06 : 08:54:45
|
| In your execute sql task, how are you calling the procedure? It should be something like exec sp_procname ?,?,? where there is one question mark per paramter. Then on the parameters tab you assign the variable that each parameter uses.Chuck P |
 |
|
|
|
|
|
passing parameter to stored procedure