Hi..
I’m continuing in the review of the Advanced ETL Processor and I understand that the Processor can download files from the FTP location.
I’ve already set up an FTP connection.
Now I’m trying to go out to the FTP location, look for a particular file mask, decode the file, download it to a directory (so that the raw data file can be saved) and then load it to a table. Under the Packages,
I’ve set up an FTP Package and from here I was putting in the actions.
When I put in a Mask, all of the files instead of just the one I want to be downloaded are downloaded. I’ve tried putting in the full name of the file and that doesn’t same to work. Is the purpose of the Mask field to tell the action what file to look for or is it for something else? Also, on a daily basis, the file mask would pretty much be the same with the exception of the date being the current date.
For example, I want to pull in the MBSAll.rep.YYYYMMDD for a given day and we would pull this file in daily M-F, how would I need to set this up in the actions so the process would know to look for today’s file?
David
