This is nothing to do with Datastage.
Before use the command in the file stage, try with dos command line using ls command.
for example
ls \\pd4p-ccbv-w01\d$\Cognos\DATAMA~1\SOURCE~1\FCUNIT~1\*.CSV
In the initial example you have mentioned space in the file name,whereas now so space.
We don't know what exactly you have there! So try to use to the ls command and once you managed to list the files, in theory you can use that without ls should work.
Reading multiple files from network using Sequential stage
Moderators: chulett, rschirm, roy
I tried ls on command line as mentioned above and it listed all the files in the directory and they are:
//pd4p-ccbv-w01/d$/Cognos/DATAMA~1/SOURCE~1/FCUNIT~1/Historical Volumes-APR-14.csv
//pd4p-ccbv-w01/d$/Cognos/DATAMA~1/SOURCE~1/FCUNIT~1/Historical Volumes-AUG-13.csv
//pd4p-ccbv-w01/d$/Cognos/DATAMA~1/SOURCE~1/FCUNIT~1/Historical Volumes-DEC-13.csv
//pd4p-ccbv-w01/d$/Cognos/DATAMA~1/SOURCE~1/FCUNIT~1/Historical Volumes-DEC-15.csv
//pd4p-ccbv-w01/d$/Cognos/DATAMA~1/SOURCE~1/FCUNIT~1/Historical Volumes-FY09.csv
//pd4p-ccbv-w01/d$/Cognos/DATAMA~1/SOURCE~1/FCUNIT~1/Historical Volumes-FY10.csv
used the same in the sequential file stage as File Pattern and showing no files returned
//pd4p-ccbv-w01/d$/Cognos/DATAMA~1/SOURCE~1/FCUNIT~1/Historical Volumes-APR-14.csv
//pd4p-ccbv-w01/d$/Cognos/DATAMA~1/SOURCE~1/FCUNIT~1/Historical Volumes-AUG-13.csv
//pd4p-ccbv-w01/d$/Cognos/DATAMA~1/SOURCE~1/FCUNIT~1/Historical Volumes-DEC-13.csv
//pd4p-ccbv-w01/d$/Cognos/DATAMA~1/SOURCE~1/FCUNIT~1/Historical Volumes-DEC-15.csv
//pd4p-ccbv-w01/d$/Cognos/DATAMA~1/SOURCE~1/FCUNIT~1/Historical Volumes-FY09.csv
//pd4p-ccbv-w01/d$/Cognos/DATAMA~1/SOURCE~1/FCUNIT~1/Historical Volumes-FY10.csv
used the same in the sequential file stage as File Pattern and showing no files returned
HB
Now you have the space in the file names
can you able to create few test files without space and place it the same server and try to read it!
This will eliminate the file path issue. Next concentrate with the file space issue.
can you able to create few test files without space and place it the same server and try to read it!
This will eliminate the file path issue. Next concentrate with the file space issue.
Thanks
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
The file names which I mentioned in my previous post without spaces are the short names of the files which I got them using this command in cmd line:
cmd /c for %A in ("\\pd4p-ccbv-w01\d$\Cognos\Data Manager\Source csv Files\FC Units Shipped\Historical Volumes*.csv") do @echo %~sA
Coming to space issue: I don't think space is causing the issue because I ran my job for single file using below filename and it ran fine:
//pd4p-ccbv-w01/d$/Cognos/DATAMA~1/SOURCE~1/FCUNIT~1/Historical Volumes-APR-14.csv
Also, I created 3 files with out spaces and single file works not if I try to read multiple files
cmd /c for %A in ("\\pd4p-ccbv-w01\d$\Cognos\Data Manager\Source csv Files\FC Units Shipped\Historical Volumes*.csv") do @echo %~sA
Coming to space issue: I don't think space is causing the issue because I ran my job for single file using below filename and it ran fine:
//pd4p-ccbv-w01/d$/Cognos/DATAMA~1/SOURCE~1/FCUNIT~1/Historical Volumes-APR-14.csv
Also, I created 3 files with out spaces and single file works not if I try to read multiple files
HB
Yes i have changed the method to File Pattern and also set the environment variable to read File pattern as file set.
Below are the warnings:
Sequential_File_0: When checking operator: No files found for pattern.
Sequential_File_0: When checking operator: Fileset C:/Windows/TEMP/import_tmp_91445e0be0c0.fs contains no files. If a file pattern was specified this indicates the pattern returned no files.
Below are the warnings:
Sequential_File_0: When checking operator: No files found for pattern.
Sequential_File_0: When checking operator: Fileset C:/Windows/TEMP/import_tmp_91445e0be0c0.fs contains no files. If a file pattern was specified this indicates the pattern returned no files.
HB