The only info I can find on syntax for using global vars is in activex
script or in an sql query.

I have already added a global variable and set a default value in the
package properties. I have a Process Execution Task and would like to
use the value of the global variable as the parameter to be passed to
the process. There is a field for the parameter, but putting:
DTSGlobalVariables("pl_output_filename").Value
in the parameter field doesn't seem to work.

Thanks in advance for any help.

Try building the statement up front

How to manipulate the Execute Process task.
(http://www.sqldts.com/default.aspx?251)


--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


<shumaker (AT) cs (DOT) fsu.edu> wrote