Hi,

i am using win 2000 client and sqlserver 2000

I have 3 questions:

1. i am using global variables to pass data to a query in an exec sql.
It works fine when i use the "?" placeholder for the parameters.
The problem is that when i am using like 20 parameters, it is a pain
to map global variables to parameter1,parameter2.......parameter20.

So i right clicked the question mark in the build query box and tried
to specify names for teh paramters using prefixes and suffixes for the
names. e.g @paramname@, @paramage@ adn so on

But this doesnt seem to work - I get an error that says "deferred
prepare....."

Am i getting something wrong? Is it possible in teh first place to
replace the ? marks with those names and to have those names display
in the right hand side column while mapping parameters instead of
Parameter1, Parameter2 etc ?

2. Stepping through

Is it possible to step through execution in a package? or at least in
an activex script?

i have enable JIT debugging but am not able to debug like I used to be
able to in the VB editor.

3. workflow activex scripts
are these always executed before execution of the task they are
attached to?

Thanks,
Madhusudhan

Madhusudhan,

1. We all live with it and that is the only way within the task.
2. It is possible to step through activeX code. Just add a STOP command to
the code. Be careful when adding STOP to an activeX in a Transformation task
when it cycles 100+ times.
3. Yes.

Ilya

"Madhusudhan" <gurumum (AT) email (DOT) uc.edu> wrote