Using multiple global variables

#1

Hello all. We have a dts package that has 2 global variables, which will be
used in the WHERE clause of a SELECT statement in a data pump. However, we
don't know how to differentiate between the two, because both are referenced
using the "?" question mark. Here's our WHERE clause, with PARAMETER1 and
PARAMETER2 used to differentiate between the two. Thanks in advance.

....
WHERE
((RTFILE_SP.RT_TERM = PARAMETER1) OR (RTFILE_SP.RT_TERM = PARAMETER2))
AND
((RCFILE_ROOT_SEG.RC_TERM = PARAMETER1) OR (RCFILE_ROOT_SEG.RC_TERM =
PARAMETER2))
....

#2

Nevermind for the brainless question

you can indicate which ? goes with
which parameter after you enter the ? marks into the query. Duh!

"dw" <cougarmana_NOSPAM (AT) uncw (DOT) edu> wrote

Quote:

Hello all. We have a dts package that has 2 global variables, which will
be
used in the WHERE clause of a SELECT statement in a data pump. However, we
don't know how to differentiate between the two, because both are
referenced
using the "?" question mark. Here's our WHERE clause, with PARAMETER1 and
PARAMETER2 used to differentiate between the two. Thanks in advance.

...
WHERE
((RTFILE_SP.RT_TERM = PARAMETER1) OR (RTFILE_SP.RT_TERM = PARAMETER2))
AND
((RCFILE_ROOT_SEG.RC_TERM = PARAMETER1) OR (RCFILE_ROOT_SEG.RC_TERM =
PARAMETER2))
...

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

Using multiple global variables

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

Using multiple global variables - 11-17-2003 , 12:49 PM

Re: Using multiple global variables - 11-17-2003 , 12:52 PM