I have a DTS Job with a Global Parameter set. When I use the ? I get the error

'No value given for one or more parameters'.

I have done a search on this newsgroup but only found a response concerning
comments. I have no comments in my Query. Is it something to do with the
Disconnected Edit. I think I may have had this problem before but cannot
remember the solution.

Thanks

How are you using the ?

At design time things are not as stable as they could be so we have to
sometimes resort to workarounds like this

Global Variables and SQL statements in DTS
(http://www.sqldts.com/default.aspx?205)

--


Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com



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

I have an SQL Task which consists of the following ;

update s_UKLtd
set dept = ?
where dept is null

I have re-created the DTS Job but still no joy. I have another one very
similar which seems to run OK

"Allan Mitchell" wrote: