DTS global parameters error

#1

Hi all,
I have a DTS package that queries couple of tables and exports to a flat
file. It runs good if I provide all the parameters. But if I use ? in the
where clause it gives me the following error:
"No value given for one or more parameters"

I did define a couple of global parameters and attached them through the
"Parameters" button on the "Transform Data Task Properties" window.....

Any help is greatly appreciated......
_Uday

#2

So at what point does it throw the error?

Design time or runtime?

If it is at design time then what is the statement you are using?

"Uday" <Uday (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi all,
I have a DTS package that queries couple of tables and exports to a flat
file. It runs good if I provide all the parameters. But if I use ? in the
where clause it gives me the following error:
"No value given for one or more parameters"

I did define a couple of global parameters and attached them through the
"Parameters" button on the "Transform Data Task Properties" window.....

Any help is greatly appreciated......
_Uday

#3

Take any comments you may have out of the query and give it a try.

--
Simon Worth

"Uday" <Uday (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi all,
I have a DTS package that queries couple of tables and exports to a flat
file. It runs good if I provide all the parameters. But if I use ? in the
where clause it gives me the following error:
"No value given for one or more parameters"

I did define a couple of global parameters and attached them through the
"Parameters" button on the "Transform Data Task Properties" window.....

Any help is greatly appreciated......
_Uday

#4

YESSSS...!!!
Worked really good after removing the comments.
Thanks a Lot..!!

Now, I'll try to run it from command prompt with parameters.

Thanks again,
_Uday

"Simon Worth" wrote:

Quote:

Take any comments you may have out of the query and give it a try.

--
Simon Worth

"Uday" <Uday (AT) discussions (DOT) microsoft.com> wrote in message
news:A4629659-3C8F-496E-A178-4E68A4BE65D9 (AT) microsoft (DOT) com...
Hi all,
I have a DTS package that queries couple of tables and exports to a flat
file. It runs good if I provide all the parameters. But if I use ? in the
where clause it gives me the following error:
"No value given for one or more parameters"

I did define a couple of global parameters and attached them through the
"Parameters" button on the "Transform Data Task Properties" window.....

Any help is greatly appreciated......
_Uday

#5

Glad that helped.
The error message isn't really helpful in this case.

--
Simon Worth

"Uday" <Uday (AT) discussions (DOT) microsoft.com> wrote

Quote:

YESSSS...!!!
Worked really good after removing the comments.
Thanks a Lot..!!

Now, I'll try to run it from command prompt with parameters.

Thanks again,
_Uday

"Simon Worth" wrote:

Take any comments you may have out of the query and give it a try.

--
Simon Worth

"Uday" <Uday (AT) discussions (DOT) microsoft.com> wrote in message
news:A4629659-3C8F-496E-A178-4E68A4BE65D9 (AT) microsoft (DOT) com...
Hi all,
I have a DTS package that queries couple of tables and exports to a
flat
file. It runs good if I provide all the parameters. But if I use ? in
the
where clause it gives me the following error:
"No value given for one or more parameters"

I did define a couple of global parameters and attached them through
the
"Parameters" button on the "Transform Data Task Properties"
window.....

Any help is greatly appreciated......
_Uday

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS global parameters error

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS global parameters error - 03-10-2005 , 01:47 PM

Re: DTS global parameters error - 03-10-2005 , 02:06 PM

Re: DTS global parameters error - 03-10-2005 , 02:56 PM

Re: DTS global parameters error - 03-11-2005 , 02:05 PM

Re: DTS global parameters error - 03-11-2005 , 02:54 PM