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 |
|
papillon2811
Starting Member
18 Posts |
 Posted - 2007-01-25 : 03:58:43
|
| Hi I am getting error while passing parameter in SSIS packageI am writing following query in sql command select * from Mytable where empid in (select empid from testtable where empid = ?)Error:Parameter cannot be extracted from the SQL Command. The Provider might not help to parse parameter information from the command. In that case, use the "SQL Command from variable" access mode, in which the entire SQL command is stored in a variable.can any body help me outThanks |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-01-25 : 10:03:32
|
| Try using @param for the parameter instead of ?Also, you query makes no sense, it's the same as select * from Mytable where empid = @param |
 |
|
|
|
|
|
error while passing parameter???