Hello!

I am trying to write an activeX script that would
check whether a text file exists in a directory or not.

I receive this text file every day, so my scheduled DTS
would only run if the text file has been saved into the
specific dir.

And based on that evaluations will proceed with other dts
tasks.

Any ideas are very appreciated.

thanks!!

In message <b98601c47998$b5fca5c0$a301280a (AT) phx (DOT) gbl>, martino
<anonymous (AT) discussions (DOT) microsoft.com> writes
How can I check if a file exists?
(http://www.sqldts.com/default.aspx?211)

How to check the file date
(http://www.sqldts.com/default.aspx?238)
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

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