Get the List of Files Using PowerCenter FTP Connection

I need to implement a mapping in PowerCenter that will access by FTP conection to a set of files, export, processing and send the file with FTP to the same server. The files to process has the following name: FSEQ_ <Type> _ <YYYYMMDD>_<Sequential_Number>

Since there may be files of various days, for the same that could be have more than one file. I cannot identify how many files are for processing in each execution and the name of each file. There may be two types of files identified by <Type>, each with their layout.

The only way to connect to the server where the files are the FTP connection is established to PowerCenter, my doubt is using the FTP connection how can I get a list of files to be exported?

That way I'll know how many files have been created and then be able to export one by one to the PowerCenter server, which will be processed.

In the case of multiple files the idea would be to create a loop to process each file individually. Through PowerCenter can be implemented as a cycle or the only solution is to perform the cycle via script?

Popular White Paper On This Topic

You can DO it easily if you are pulling the source with indirect method.
If you have a log file containing list of file names in source directory, Develop a mapping with source as flat file,create/add file name field and parametrize the source file name based on date field and connect it to a TC transformation. Commit source based on file name and you can get the list of source file names in a target flat file.

Copyright 1998-2015 Ziff Davis, LLC (Toolbox.com). All rights reserved. All product names are trademarks of their respective companies. Toolbox.com is not
affiliated with or endorsed by any company listed at this site.