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 |
|
santoshini_mohini
Starting Member
5 Posts |
 Posted - 2009-01-21 : 00:45:18
|
| Hello,In OleDb Source , i selected SQL coomand as Access mode and i defined an Exec statement which accepts single parameter. And from the parameter tab i selected the corresponding user parameter for which i had already defined a default value for which the SP executes. When try to preview the result set i use get an error like "No value given for one or more required paramters" , though i have already mapped with the parameter ..Can anybody help me on this ??Santoshini |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-21 : 09:27:41
|
| yup.its a known issue.you cant use parameters using sql command mode. for this you need to use "SQLcommand from variable" option. then create a string variable to hold the sql statement, set evaluate as expression property to true for it in properties window and give expression as 'EXEC....,' + @[user::yourcreatedvariable] by clicking ... next to expression and typing above in expression builder (make sure you test run expression inside expn builder). then map this variable in variable mapping field of OLEDB task. |
 |
|
|
santoshini_mohini
Starting Member
5 Posts |
Posted - 2009-01-21 : 23:31:14
|
| Thanks , i tried that and its working fine nowSantoshini |
|
|
|
|
|
|
Error using OleDb Source in SQL 2005