Very Computer

by **vinay manth** » Fri, 16 Aug 2002 02:38:08

I have SQL 2k client installed on my system, and i design dts packages from
here which are saved on a different server. I have encountered a very weird
issue with input/output parameters on my system. When i try to create an
output parameter from a sql statement, it is not retaining the value, and i
am getting the error "no parameter value has been supplied" when i try to
read that parameter as an input parameter in another task. What is weird is
that if i open the package on another server, and then reset the parameters,
it works correctly. For another package, i saw that the "parameters" tab for
an "execute sql task" greyed out, which means that i cannot specify an input
or an output parameter, for the same package it works fine when i open it
from another machine. Is it an issue with DTS on SQL 2k client machines? The
other machines i looked have the server software on them. Thanks

Vinay

by **Paul Kohlmille** » Sat, 17 Aug 2002 09:40:26

More clarification of the problem may help here. When I use an Execute SQL
Task I don't see a "parameters" tab but a "parameters" button. Is this what
you meant? Also, for me this button becomes enabled as soon as I enter a
single character in the query text field. You don't?
Now, the output parameter is a global variable, yes? And you see this
behavior (not retaining the value) when you execute the whole package (as
opposed to just each step separately)?
I do most of my DTS work on a client machine but there is a server on that
machine (almost always not in use but ...).
HTH,
PK

Quote:> I have SQL 2k client installed on my system, and i design dts packages
from
> here which are saved on a different server. I have encountered a very
weird
> issue with input/output parameters on my system. When i try to create an
> output parameter from a sql statement, it is not retaining the value, and
i
> am getting the error "no parameter value has been supplied" when i try to
> read that parameter as an input parameter in another task. What is weird
is
> that if i open the package on another server, and then reset the
parameters,
> it works correctly. For another package, i saw that the "parameters" tab
for
> an "execute sql task" greyed out, which means that i cannot specify an
input
> or an output parameter, for the same package it works fine when i open it
> from another machine. Is it an issue with DTS on SQL 2k client machines?
The
> other machines i looked have the server software on them. Thanks

> Vinay

Very Computer

Weird Issue with my DTS Designer- Microsoft Bug ??

Weird Issue with my DTS Designer- Microsoft Bug ??

Weird Issue with my DTS Designer- Microsoft Bug ??