Monitoring a folder

Hi everyone,
I need to monitor a folder to and write in a table the filename and datetime
of every file when it is added. Is it possible to do this in sql server or I
have to write a program to do this?
Thanks..
_Mario_Mario
You will be better of writing some program (.NET)
"Mario" <mariomario75@.yahoo.com> wrote in message
news:Obp4N9kUGHA.2444@.TK2MSFTNGP14.phx.gbl...
> Hi everyone,
> I need to monitor a folder to and write in a table the filename and
> datetime of every file when it is added. Is it possible to do this in sql
> server or I have to write a program to do this?
> Thanks..
> _Mario_
>|||I think that it's possible do it using Sql but at the outset seems more
useful and easier take advantatge of VBScript
--
Current location: Alicante (ES)
"Mario" wrote:

> Hi everyone,
> I need to monitor a folder to and write in a table the filename and dateti
me
> of every file when it is added. Is it possible to do this in sql server or
I
> have to write a program to do this?
> Thanks..
> _Mario_
>
>|||Do you mean a scheduled dts?
Mario
"Enric" <vtam13@.terra.es.(donotspam)> ha scritto nel messaggio
news:B542903E-2A4A-42D4-A733-EBC43C146E33@.microsoft.com...
>I think that it's possible do it using Sql but at the outset seems more
> useful and easier take advantatge of VBScript
> --
> Current location: Alicante (ES)
> "Mario" wrote:
>|||yeah,i was walking about dts.
We have a service which is running all day long checking up if there are
files in a folder list and if so launch a DTS with these files. But that
service is built with VB 6.0 and FSO
--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''s hard to provide information
without seeing the code. location: Alicante (ES)
"Mario" wrote:

> Do you mean a scheduled dts?
> Mario
>
> "Enric" <vtam13@.terra.es.(donotspam)> ha scritto nel messaggio
> news:B542903E-2A4A-42D4-A733-EBC43C146E33@.microsoft.com...
>
>|||The best approach is to do this in front end application
Madhivanan