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.
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
According to the error message it seems that the program does not understand the definition of the file:
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):
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.