Does anyone have an idea on how to listen for and process an incomin Excel file in Data Migrator? As near as I can tell from the documentation, the file listener facility only works for flat files. I can read and process the Excel file just fine, but I need to listen for it.

Tbanks in advance.

The file listener also works for delimited files, so rather than send Excel workbooks as-is, what most customers do is export delimited files and copy or FTP them to the DataMigrator server. If you can do that, I think it's the easiest way.

Otherwise there is new listener functionality in Release 7.7.04 to monitor a directory for files butnot read them. Then when a file arrives you could initiate a data flow to process it, regardless of type.

Thank you Clif. I see the new 7704 functionality mentioned in the New Features Guide, but do not find the documentation for using it anywhere. Where might I find this please.

For the source see "Reference: Prototype File Monitory (sic) Synonym" on page 616.

For your purpose for the target you could use a flat file with one column to contain the full file name. And then use that to supply the DATASET name for the excel (direct retrieval) synonym.