DTS Dynamic Properties

You can use:

 DTSGlobalVariables("SERVER_NAME").Value

in your ActiveX scripts to reference global variables in the package.  SERVER_NAME is a variable name you create.


You can also setup a "Dynamic Properties Task" within a package to manage connections for a package.

The kicker is how do you use a dynamic property concatenated with a static string in, for example,
 the file name box
in the connection properties for a source text file connection ?