"Tom" <anonymous@discussions.microsoft.com> wrote in message
news:anonymous@discussions.microsoft.com:

> Thanks........The bad news is that we don't use .NET (I
> don't know why - I am not a decision maker). especially on
> a production server. Is there any other solution ?
>
> Thanks.
>
>
>
>
> >-----Original Message-----
> >How about, and I do this, watch for the files using a
> service that
> >incorporates the FileSystemWatcher class in .Net.
> >
> >This watches for files and then fires the packages.
> >
> >Allan
> >
> >"Tom" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:anonymous@discussions.microsoft.com:
> >
> >> We have a DTS package that loads 46 text files from an
> FTP
> >> server into the database on a database server at 6:00
> AM.
> >> every morning. The files are sent to FTP server at a
> >> various times. Even though the DTS Package is scheduled
> to
> >> run at 6:00 AM, is there a way of loading the data into
> >> the database as soon as the files are received on the
> FTP
> >> server ?.
> >>
> >> Something like trigger or script or a process that
> >> constantly checks if the files are there and when it
> sees
> >> the files, it starts to execute the DTS package to load
> >> the database.
> >>
> >> T.I A.
> >
> >.
> >