AnsweredAssumed Answered

Unable to use CSV Input with file on a UNC (network path)

Question asked by Sam Alexander on Apr 23, 2019
Latest reply on May 28, 2019 by Sam Alexander


I'm using Data Integration 8.1 on Windows, and using CSV Input I have the CSV on a network drive - \\DevServer\Dev\test.csv for example.  When I create the CSV File and put the path in Filename I click Get Fields which loads the files just fine.  But when I Preview or use the CSV Input to say feed a table I get this error:

 

2019/04/23 13:30:11 - Claims - STG_CLAIM.CSV 2.0 - ERROR (version 8.1.0.0-365, build 8.1.0.0-365 from 2018-04-30 09.42.24 by buildguy) : Unexpected error

2019/04/23 13:30:11 - Claims - STG_CLAIM.CSV 2.0 - ERROR (version 8.1.0.0-365, build 8.1.0.0-365 from 2018-04-30 09.42.24 by buildguy) : org.pentaho.di.core.exception.KettleException:

2019/04/23 13:30:11 - Claims - STG_CLAIM.CSV 2.0 - java.io.FileNotFoundException: file:\DevServer\Dev\test.csv (The filename, directory name, or volume label syntax is incorrect)

 

Even when I browse to the CSV it finds it fine, but it just won't work.  Any thoughts or tricks?  If I move the file to C:\ and use C:\test.csv it works fine, so I know it's not the file.  Thanks.

Outcomes