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!

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


"Nexx" <nex (AT) nexx (DOT) com> wrote

Nexx:

Yes. For example:

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

Hope this helps.

Paul

"Nexx" <nex (AT) nexx (DOT) com> wrote