I have a dts job that runs on my MSSQL2000 win2K box.

But i want to be able to trigger this dts job to run when
a three files are loaded into a certian directory.

I can have trigger files uploaded at the same time but
am just wondering what ways their are to acchive my goal?

I dont want to really install any other software on the
box but if is is somthing microsoft then i am sure that i
could warm to the idea.

Willa

In message <372901c4297f$0c8896c0$a601280a (AT) phx (DOT) gbl>, willa
<will (AT) ncl (DOT) com> writes
There is nothing MS supplied that will do this. You can write code that
will watch a directory and trigger suitable actions, but it is not DTS
or MS packaged solution

Why not just schedule a job that runs regularly and calls your package.
First thing the package does is check if the file exits, if not then end
quietly.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org