I'm trying to implement an SSIS package but have run short of ideas on
how to best do it.

I need to send a group of uniquely named data request scripts (with
file extension .req), to an FTP location. After a short (but unknown)
length of time, a similarly named data file will appear at the ftp
location, which I'd like to download.

I can get this to work using two packages: the first sends the
requests, and the second retrieves and processes the resulting data
after an estmated amount of time (hoping the resulting files will be
there).

However, I'd like to do this with one script, perhaps with with a
foreach loop, enumerated along each request file. I can't think of a
clever way to get the package to wait until the .out file (data file)
is generated before downloading & processing.

any thoughts?

Hello christopherdbradley (AT) gmail (DOT) com,

So would you want something like a File System Watcher that raised an Event
when a file with a given pattern was dropped in a directory of your choosing?
This way you would know that you can go and get the file. The task would
simply wait until the file was found or duration threshold was reached.



Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

I'm not sure if that would work. Can a File System Watcher monitor an
FTP location?

I need to find a way of triggering subsequent events when a file
appears at the remote location.

thanks,
CB



Allan Mitchell wrote:

and, if at all possible, I'd like to limit my use of coded scripts...
my syntax is terrible!


christopherdbrad... (AT) gmail (DOT) com wrote: