Global Variables On query

Question

Global Variables On query

mdriscoll

SSC Enthusiast

Points: 166
More actions
October 18, 2002 at 12:00 pm

#158514

Hi i'm using ss 2000. Im in a dts package and need to use a global in a query (execute sql task). I figured out that I can type a "?", then click parameters, but it always inserts "Null"
ANy IDEas?

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

mhweiss SSCarpal Tunnel Points: 4284 More actions · Answer 1

In your package, you need to create a global variable. Then on the execute sql task, click on the global variables (parameters?) button and there you can assign the value of the global variable to the parameter in your sql statement. Of course, you will need to set the global variable value in some way...via an input box in an activex task for instance, or pull it from another task object...

hth,

Michael

Michael Weiss

mdriscoll SSC Enthusiast Points: 166 More actions · Answer 2

Thanks for the fast reply.

I do have a global variable from another sql task object. I know it works because I use it in a active x script. When I asign it to the ? in another sql task object (writing to a log table) my resulting record is "NULL" in that column. its wierd, because my sql parses correctly - no errors.

mhweiss SSCarpal Tunnel Points: 4284 More actions · Answer 3

In the second sql task, the one in question, are you assigning the variable as an input variable? if so, then I do not have a clue off the top of my head about why it is not passing in a value to your query statement...

Michael

Michael Weiss

mdriscoll SSC Enthusiast Points: 166 More actions · Answer 4

ok, stamp a big "LOSER" on my head. The data type for the variable was different than my column data type!

thanks for the help anyway