Re: Accessing DTS Global Variables (please help!)???
"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
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
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center