Hi,

Is it possible using the DTS to monitor a CSV file and
import it into a table only when it has changed, i.e. the
date and time stamp.

Any help greatly appreciated

Martin

Either

1. Periodically check the files in the directory and log their dates to a
table. On the next iteration you would check to see if this had changed.
OR
2. This is the way I would do it. In .Net use the FileSystemWatcher class
to look at the modified event for the text files in a directory.



--

----------------------------
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



"Martin" <martin4nospam (AT) yahoo (DOT) co.uk> wrote

Hi Allan,

We are not using .NET infrastructure

Would we use vb script in the DTS to watch the time and
date or is there a TransactSQL command to do this.

Can you give me some pointers to this as I have limited
experience with using the DTS, unless it is a wizard of
course.

Regards

Martin

Have a look at this.

How to check the file date
(http://www.sqldts.com/default.aspx?238)

You would log details using ADO to SQL Server

You would loop through a directory using (Step 4)

Looping, Importing and Archiving
(http://www.sqldts.com/default.aspx?246)



--

----------------------------
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



"Martin" <martin4nospam (AT) yahoo (DOT) co.uk> wrote

In article <3f9701c37611$dccc6450$a001280a (AT) phx (DOT) gbl>, Martin
<martin4nospam (AT) yahoo (DOT) co.uk> writes
You can do this via Win32 APIs. Here is a VB 6 sample-

http://www.mvps.org/vbnet/code/filea...chedfolder.htm

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