Monitoring a folder for a file - start ssis

Hi

I want my package to monitor a directory for a file and when it detects one it will start processing the file. Any help would be appreciated

Regards

Ants

The only (and easy) idea that comes to my mind is to schedule the package to run n times a day and to include conditional logic in control flow based in the existence of files on the folder.

Rafael Salas

|||

You can use the WMI task to do this. There is a sample in BOL.

Or, you can download the fileWatcher Component. http://www.sqlis.com/default.aspx?23

|||WMI is a good option here and the WMI Watcher Task will help you to achieve the same.

I remember reading somewhere that the memory used by the package will

be released only when the package is stopped, so in your case if the

package is going to be waiting for the file (package in run state), we

need to consider the side effects of memory.

Thanks,

S Suresh

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