SSIS ERROR Error - SQL Server Forums

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.

All Forums

SQL Server 2012 Forums

SSIS and Import/Export (2012)

SSIS ERROR Error

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources