Link to home
Start Free TrialLog in
Avatar of ZayanAwais
ZayanAwaisFlag for Saudi Arabia

asked on

Read Multiple Files From FTP Folder And Load Their Content into Database

Dear Experts,

I want to read multiple structured CDR files everyday from a folder on FTP and load their contents into a staging Table. The files generated each day with random name but the length of the file name is fixed. I am using Ascential Datastage v7.5.1A And Oracle Database on Windows Server 2003.

Please need your help to create a job using components of Datastage v7.5.1A to read  multiple files in a loop and load their contents into a staging table.
ASKER CERTIFIED SOLUTION
Avatar of AlexPace
AlexPace
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ZayanAwais

ASKER

Thanks Alex,
but right now my first priority is to read multiple files in a loop and load their content into the table. Please help me in this regard.