Basics on looping through text file. -- sql server dts

Ron Sissons
4/13/2004 1:42:22 PM

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

Darren Green
4/14/2004 8:01:01 AM

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

[quoted text, click to view]

sql server dts : Basics on looping through text file.