418nicr
05-19-2010, 04:28 PM
Hi! I have a fixed input file step which works fine when I specify the absolute
path + filename without any variables i.e: c:\dirA\dirB\myFile.txt
but when I use a variable in the filename input field of the step (in version 3.2.0 GA )
I get weird behavior. I have a variable named "processingDir" and a constant file name: so the field contains: ${processingDir}\myFile.txt
Load file content 3.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : java.io.FileNotFoundException: \devsandbox\kettle\data-integration\C:\dirA\dirB\myFile.txt (The filename, directory name, or volume label syntax is incorrect)
So, basically it seems the problem is with the handling of the filename from the step. Spoon/kettle always try to use the path as relative to kettle_home instead of allowing an absolute path (when using variables).
I've looked at the source and couldnt figure it out.
In the transformation xml file, the filename node is <filename>${processingDir}\myFile.txt</filename>
Anyone?
path + filename without any variables i.e: c:\dirA\dirB\myFile.txt
but when I use a variable in the filename input field of the step (in version 3.2.0 GA )
I get weird behavior. I have a variable named "processingDir" and a constant file name: so the field contains: ${processingDir}\myFile.txt
Load file content 3.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : java.io.FileNotFoundException: \devsandbox\kettle\data-integration\C:\dirA\dirB\myFile.txt (The filename, directory name, or volume label syntax is incorrect)
So, basically it seems the problem is with the handling of the filename from the step. Spoon/kettle always try to use the path as relative to kettle_home instead of allowing an absolute path (when using variables).
I've looked at the source and couldnt figure it out.
In the transformation xml file, the filename node is <filename>${processingDir}\myFile.txt</filename>
Anyone?