I am atempting to write a DTS to pick up text files from
a derectory to be imported into two tables Although all
the files will be in the same format, they will all be
have differnet names and extensions.

The DTS will be running as a task every few minutes, Is
there anyway to
1. build an array of the file names so that i can then
do the importing from the files
2. stop the DTS from running if it is aready running so
that i dont duplicate the imports?

any help would be greatefully recieved

Thanks

Have a look at this

Looping, Importing and Archiving
http://www.sqldts.com/default.aspx?6,103,246,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



"Peter Newman" <pete (AT) cashbacs (DOT) co.uk> wrote