VBScript and G.Variables -- sql server dts

Nexx
6/25/2004 10:19:19 AM

Greetings everyone,
I have a dts package with a dynamic properties task and the typical
assortment of sql queries, connections, etc... The dynamic properties
task exists to set the properties of various global variables which are
to be passed in from the command line.

Question, can I set one of the global variables properties equal to
the results of a vbscript function?

Thanks!

paulb NO[at]SPAM pointinformationsciences.com
6/25/2004 2:07:35 PM

Nexx:

Yes. For example:

DTSGlobalVariables("SampleVariable").Value = Results of function.

Hope this helps.

Paul

[quoted text, click to view]

Allan Mitchell
6/25/2004 5:53:24 PM

Yes by assigning the value through an Active Script task not the Dynamic
Properties task.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : VBScript and G.Variables