DSXchange

Hi,

I am trying to load AQL from a file which is created from another job.
I am using Oracle OCI stage. In the Stage Tab, i have given the correct credentials.
In the Output tab, in General Tab, i have selected "Load SQL from file at Runtime". In Columns under Output, i have given the output columns.
In the SQL tab under Output, i have selected "Load SQL from file at Runtime".
In the place where the custom sql is present, i have given "sqlfile.sql/#SQLFILE#" where sqlfile.sql is the sql filename and #SQLFILE# is the parameter which contains the path of the sqlfile.

When i execute, i am getting the below error.

"Can not open the file that contains the SQL statement".

Can someone point out as what iam doing wrong.

Thanks !! Cheers!!

Put the path before the file name.

Right, you seem to have the two parts backwards.

Then just as a FYI, the OCI is deprecated and you'll want to get on the new Oracle Connector and migrate your old jobs to use this. We're experiencing some pain ourselves having delayed this code update and we're now being forced into updating before we can continue upgrading the environment.