Hi,

Can SQL Server 2000 find a text file has been updated and import the updated
text file to the database table?

Thanks.

Mindy

Kind of broad but one basic approach would be to use a
control table to store the last updated date of the file.
You can have a job that runs however often which uses the
FileSystemObject to check the files DateLastModified
property, compare what you have in the table with the
DateLastModified. If DateLastModified is different, execute
a DTS package to import the file.

-Sue

On Mon, 10 Nov 2003 16:38:05 -0500, "Mindy Zhang"
<mindyzhang (AT) hotmail (DOT) com> wrote:

The approach I use is to use the FileSystemWatcher class in .Net and use the
events from that to note if a file has been changed.

--

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


"Mindy Zhang" <mindyzhang (AT) hotmail (DOT) com> wrote