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 |
|
Blessed1978
Yak Posting Veteran
97 Posts |
 Posted - 2015-02-13 : 12:14:42
|
I am running the below in SSIS 2010 AND KEEP GETTING ERROR MESSAGE
"Error
No value given for one or more parameters". cAN SOMEONE ASSIST
Querry in my OLE DB SOURCE EDITOR
select DISTINCT
c.EMPID
, c.CST_DISPLAYNAME as Display_Name
, e.TASK
, e.TASK_NAME
, c.eMP_EMAIL as Employee_Email
from MBA.COMMITTEE ep
inner join MAB.MEETINGS e on e.MEETINGS_ID = ep.COMMITTEE_ID
inner join MBA.INDUSTRY c on c.INDUSTRY_ID = ep.COMMITTEE_ID
WHERE ? = 1
SET QUERRY PARAMETER
pARAMETERS varaiables Param
@var_RUNALL User::var_RUNALL Input
Varaiables
Name sCOPE Datatype Value
var_RUNALL Members Int32 0
no expression
Error
No value given for one or more parameters |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-02-13 : 12:26:11
|
There is no SSIS 2010. SQL Server (and SSIS) had no 2010 release. I suppose you are working on the package in Visual Studio 2010 and that your SQL Server is actually 2008R2. Is that correct?
I think your problem is here:
WHERE ? = 1
How should that question mark be resolved by SSIS before sending the query to the server? That's the parameter it's referring to. |
 |
|
|
Blessed1978
Yak Posting Veteran
97 Posts |
Posted - 2015-02-13 : 12:55:39
|
Yes I am using visual studio 2010
You can use ? To initialize the parameter so
I don't believe that's the issue |
|
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-02-13 : 13:07:57
|
| You can use the question. But, what is in your parameter mapping? |
|
|
|
Blessed1978
Yak Posting Veteran
97 Posts |
Posted - 2015-02-13 : 14:30:54
|
WHEN I OPEN my ole db sourse editor then go click parameters
a SET QUERY Parametere windoW opens up here are my values
PARAMETERS VARIABLES PARAM DIRECTION
var_RUNALL USER::var_RUNALL INPUT
UNDER Variables
Name SCOPE DATATYPE Value Expression
var_RUNALL mEMBER int32 1 |
|
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-02-13 : 15:02:30
|
| wait, are you getting the error when trying to preview the results? That doesn't' work with parameters |
|
|
|
Blessed1978
Yak Posting Veteran
97 Posts |
Posted - 2015-02-13 : 15:03:32
|
| Yes |
|
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-02-13 : 15:28:08
|
| you'll have to live with the limitation. To see if it works, connect your source to something (even a row count) and put a data view on the connection. then Execute the DF task or the whole package in debug |
|
|
|
|
|
|
SSIS ERROR Error