Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Dynamic File Name

user10723402Apr 25 2012 — edited Apr 27 2012
Hi,

I need some help loading a set of flat files to a target table. We do not have any fixed frequency for the number files we receive per day. These files are stored in a directory in ORD_04252012_1.txt, ORD_04252012_2.txt, ORD_04252012_3.txt etc format. If I have to load all the files received each day how do I implement this logic in the variable? I used this code in the refresh tab of the variable: SELECT 'ORD_'||to_char(SYSDATE,'MMDDYYYY')||FILE_ID_SEQ.NEXTVAL||'.txt' FROM DUAL. But the problem with this is I need to run the package multiple times to retrieve each of the file in the directory. Is there any other way I can implement this?

Thanks,
Sam
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 25 2012
Added on Apr 25 2012
#business-intelligence-applications, #data-integrator, #odi, #system-management-and-integration
16 comments
8,810 views