Reading Files from the given folder

Krish

Hi ,

I have the following requirement.

I have error log folder like this:

C:\Data\App1\Error

Record1.Error

Record2.Error

I have to read the above folder for all .error files and I need to create temp table like this so that I can update against my db table.

RecordName   Status                      Error_Desc

Record1           Load Error             Content of the Record1.Error file

Record2           Load Error             Content of the Record2.Error file

Could you please provide me a direction on which tools can be used to solve this.

Thanks in advance.

Krishna

NicoleJohnson

Try the Directory tool - set it up to connect to all files in the folder using "*.*" as your file name (or "Record*.xlsx" for example if you only wanted the Excel files that started with "Record")... It will bring in the file names, full path, etc. which you can then feed into a Dynamic Input tool. Connect to one file as a template in Dynamic Input, and then indicate that the tool should replace the file name based on the field containing the file names from the Directory tool.

Let us know if that gets you headed in the right direction or if you need more assistance with configuration, etc.?

Cheers,
NJ