Well, there are many things to check :

Are all your users in the same domain ?

Is your SQL server in the domain ?

Do you use fixed IP adresses or do...

Hi,

I don't think your problem has something to with "retreiving a global variable value". 

What I understand is that in your query the table name is a variable. The only way...

Hi,

I think you should first avoid the error ... like converting the DateTime into varchar (if it's the cause of your error).

Anyway, a "Transformation data task" in a DTS pakage...

Hum !

I didn't understand you have created the variable in the ActiveX task. To be honest it has never occured to me doing that way ... and believe me, I've...

Hi !

I think your problem come from your request ! It's too COMPLEX !

For using the "?" syntax, you must use the most simple syntax.

In your case, I define a...