SQL ORACLE (9/4/2009)
How about the global variable?
I know this is an old post and I might not get an answer from you but I have to ask... keeping in mind that SSIS/DTS is not being used for this particular task, what are you calling a "global variable" in this case? To the best of my knowledge, there is no such thing as a "global variable" either in the T-SQL world nor in the SQL Server Job world.
--Jeff Moden
Change is inevitable... Change for the better is not.