Re: SSIS FTP Task
- From: Allan Mitchell <allan@xxxxxxxxxxxxxxxxxx>
- Date: Wed, 22 Nov 2006 22:31:30 +0000 (UTC)
Hello christopherdbradley@xxxxxxxxx,
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 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?
.
- Follow-Ups:
- Re: SSIS FTP Task
- From: christopherdbradley
- Re: SSIS FTP Task
- References:
- SSIS FTP Task
- From: christopherdbradley
- SSIS FTP Task
- Prev by Date: Re: Differential Data Import
- Next by Date: schedule job backup
- Previous by thread: SSIS FTP Task
- Next by thread: Re: SSIS FTP Task
- Index(es):
Relevant Pages
|
