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!

How to use a variable to get filename for the source dynamically.

2792097May 19 2016 — edited May 19 2016

Hi,

I tried creating a variable to fetch the filename dynamically as mentioned in the article How To Set Up Dynamically Specified File Name Or Directory Name For Use In An ODI Integration Interface (Doc ID 423635.1)

But, I am getting an error like

ODI-1227: Task SrcSet0 (Loading) fails on the source FILE connection Employee_Detail_Data_Server.

Caused By: java.sql.SQLException: ODI-40438: File not found: /.txt

I have used 2 variables: FileName and SchemaName in the project with code ODIEXP_FT_RT

I am using the SchemaName variable in physical schema for WorkSchema(directory) and Schema(Directory) and the FileName variable in the Resourcename for datastore.

I have defined a flow in package which starts taking values from both variables and then runs the interface and both variables in the package are of Declare Variable Type.

Please suggest a workaround.

Regards,

Janki

This post has been answered by 2792097 on May 19 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 16 2016

Added on May 19 2016

#business-intelligence-applications, #data-integrator, #system-management-and-integration

6 comments

1,671 views