0

I was trying to use a different sql script for one job. For doing this i need to pass the script by file csv, so i set the script like a variable and then i make a transformation that "copy to row" for reading the parameter. I thought that pentaho did not read the script because when i tryed to extract paramenter he does not read anything. Like i show below. This is the Transformation to configure

Inside CSV file input

Job after transformation to configure Inside "Trasformazione leggi configurazione" Inside "Trasformazione in CSV" CSV file with the query The error

1
  • Welcome to the DBA.SE community. Your question seems to a be a tool specific error. Are you inputting the correct values in the correct places? There might be an issue with the syntax. Could you provide more details in your question? Click edit and add them directly to your question. For example: What is the name of the tool you are using? What is the environment you are working in?
    – John K. N.
    Dec 15, 2021 at 8:03

1 Answer 1

0

According to the error message it seems that the program does not understand the definition of the file: ${Internal.Entry.Current.Directory}\config.csv.

Couldn't get filed info from [$(sql_script)]

ERROR: syntax error at or near "$" Posizione: 1

Try omitting the $ in the file definition (first screenshot):

{Internal.Entry.Current.Directory}\config.csv`

I'm not Pentaho expert, but unless your file contains a $ in the first line, then the error must lie in the definition of the parameter for the CSV file.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.