"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.

Like...

Select * From <table value> where field > 1

Please help!!!