Hi all,
I am building a DTS pakage to read from a text file and Populate a SQL
Server table. I am using the Enterprise manager to build the package.
I wanted to know if there is a way where I can specify information like the
path of the source text files, Login/pwd,server name of the detination
server in a separate "configuration file".
The reason I am looking for this is that I might need to move my packages to
different severs who may have different name and login/pwd. Also I dont want
to hadrcode the source file path in the package.


I think It is possible with UDL files but I dont know how.

any suggestions will be highly appreciated.

Cheers,
siaj

You can use a "Dynamic properties task".

Francesco Anti


"siaj" <siaj (AT) discussions (DOT) microsoft.com> wrote