DTS Package Load schedule issue

#1

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.

#2

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 (AT) discussions (DOT) microsoft.com> wrote

Quote:

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.

#3

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.

Quote:

-----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 (AT) discussions (DOT) microsoft.com> wrote in
message
news:anonymous (AT) discussions (DOT) 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.

.

#4

Some job schedulers have it.
WMI has it.

"Tom" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

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 (AT) discussions (DOT) microsoft.com> wrote in
message
news:anonymous (AT) discussions (DOT) 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.

.

#5

We do something similar where we fire off a job every hour to check the
existence of files on a network share, then if any are there, it
executes a dts package to load them and archive them.

Simon Worth

Tom wrote:

Quote:

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS Package Load schedule issue

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS Package Load schedule issue - 04-07-2005 , 12:56 PM

Re: DTS Package Load schedule issue - 04-07-2005 , 01:32 PM

Re: DTS Package Load schedule issue - 04-07-2005 , 02:06 PM

Re: DTS Package Load schedule issue - 04-07-2005 , 02:26 PM

Re: DTS Package Load schedule issue - 04-12-2005 , 12:46 PM