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.
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.