I am trying to modify a DTS package connection to use
a .udl file. When promoting the package I have to ensure
that there is a .udl file on every environment using the
same name in the same location. That is not a problem,
however, I would like to know if there is a way to
dynamically set this path to use a UNC path so that the
package could be executed from any server instead of
having to be locally executed.

Using a Dynamic Properties Task, you can dynamically set the "UDLPath"
Property value to a UNC path that you supply to the package (via global
variable, ini file entry, query, etc).
If this package is on many servers, then I would use a global variable
sent to the package when calling for execution, so it can set the
UDLPath for the connection when it starts.

Example
DTSRun /S "SQLServerName" /N "DTSPackageName" /A
"gv_UDLPath":"8"="\\ServerName\FolderName\UDLFile. udl" /W "0" /E

This example sets the global variable "gv_UDLPath" to
\\ServerName\FolderName\UDLFile.udl. Then when the package is run, the
dynamic properties task sets the UDLPath of the Data Link to the value
of the global variable - which is "\\ServerName\FolderName\UDLFile.udl"

Does that help?

Simon Worth

cazar wrote: