Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
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: ${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.
