DTS/TRANSACT - passing variables

[mapfax]

Is is possible to transfer the results of a @variable in Transact SQL to a global variable in VBScript?

I want to check if a file exists so I thought I would use 'xp_fileexist' before I run my ActiveX.

Declare @result int
exec xp_fileexist ‘filename’, @result output

Thanks for any help.

 

[mapfax]

I have found another way to do this, using File System Object in ActiveX. Would still be interested to know if/how variables can be passed between T-SQL and VBScript.