I have several DTS packages (108) that write results sets to files every
night. I am trying to consolidate the packages to use one package to fire
off the rest. We will be moving our database to a datacenter, which will
greatly affect the packages. The destination on the transformation is a
text file located in mapped drive. The mapped drive will be different at
the datacenter, don't know why or what it will eventually be, but I was
hoping that there was a way to use the DTSGlobalVariables to dynamically
determine the drive.

any thoughts or help would be most appreciated.

Don't use mapped drives they will only break your heart some day. Use UNC
paths. If you must use mapped drives remember to map the drive for the SQL
Server Agent account

How can I change the filename for a text file connection?
http://www.sqldts.com/default.aspx?6,101,200,0,1

--


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

"Esch" <matte (AT) codecorrect (DOT) com> wrote

Thank you, would you where I could find an example using the 'dynamic
properties task'. I would actually have three variables that would change:
State, filename, and the Path.


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote