"TechDork" <Techus@Dorkus.com> wrote:
>How can I access global variables from a Transform Data Task - in the sql
>from the Source query?
>Thanks very much!!

It appears that these global variables can only be accessed inside ActiveX
Tasks :-(

Is this true?? If so, is there anyway I can pass a parameter to my Data Transformation
Task from my ActiveX Script Task? I want to pass a table name so I can dynamically
build the sql in my Source Query in the Data Transformation Task.


Select * From <table value> where field > 1

Please help!!!