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
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL