Is it possible to kick off a DTS package automatically
trigged by the existence of the source flat files? I know
I can write an activeXscript to check for the existence of
these file but I would still have to set up the job to run
the activeXscript to look for these files. Correct?!

So, I would like a trigger that will read that file (or
its properties) and kick off the job.

Is that possible? If so , how?

Thanks in advance for your help.

Sandra

I would use the FileSystemWatcher class in .Net. This raises events which
could trigger the package.

Not using .Net you could have a job which fires every 2 mins which checks
for files and if it finds them then it fires the package.

How can I check if a file exists?
(http://www.sqldts.com/default.aspx?211)

--
--

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

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