3 Replies Latest reply: Dec 23, 2013 1:01 PM by 5cfc1403-6930-41fa-ab27-229323775db4 RSS

    Dynamic Resource name for Excel/csv files

    5cfc1403-6930-41fa-ab27-229323775db4

      Hi All,

       

      Reading from a source excel (as well as csv) file, I tried passing the resource name via a variable which is set to contain the name of the file (refresh). However, on execution, the file name shows up with an additional "\" character without being specified in the variable text causing the interface to face on load step.

       

      The error says:

       

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

      Caused By: java.sql.SQLException: ODI-40438: File not found: C:\DirectoryNameHere\ /OTD.

       

      Is this expected behavior where one needs to escape the special character?

       

      I've verified that the extra / is not present in either the variable value or the directory for the Physical Schema.

       

      TIA.