Hi,

I have server names in a txt file. like so

Server1
Server 2
Etc...

I want to be able to import the server names from the text file and update a
connection in a dts package. I checked the SQL DTS articles but most are not
good for starting point.

Any ideas?

Ron Sissons, DBA
Information Technology Services
Riverside County Office of Education
3939 Thirteenth Street, Riverside, CA 92502-0868
Telephone: (909) 826-6471; FAX: [909] 826-6451

Why not use a Dynamic Properties Task to read the file into a global
variable. You could also do this in ActiveX Script using the File System
Object. Then within ActiveX Script you can manipulate the file info, perhaps
split it into an array based on Cr+Lf, and use this for a loop driver.


--
Darren Green
http://www.sqldts.com

"Ron Sissons" <RSISSONS (AT) rcoe (DOT) k12.ca.us> wrote