Hi All,
I have two text files which have the job log of two respective jobs say Job1,Job2, in a placed in a folder. I am using another job for reading these log files everytime after the jobs are exceuted. I am trying to use the file pattern option in the sequential file, and tried giving the path of the files where they are placed like C:\folder\*.txt.
If am doing view data it is giving me the error:
##I TFCN 000001 17:59:19(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##I TOSH 000002 17:59:19(001) <main_program> orchgeneral: loaded
##I TOSH 000002 17:59:19(002) <main_program> orchsort: loaded
##I TOSH 000002 17:59:19(003) <main_program> orchstats: loaded
##W TCOS 000049 17:59:19(004) <main_program> Parameter specified but not used in flow: DSProjectMapName
##W TOIX 000000 17:59:19(005) <main_program> createFilesetFromPattern(): Couldn't find any files on host with pattern "*.txt".
>##E TOIX 000138 17:59:20(001) <Sequential_File_0> At least one filename or data source must be set in APT_FileImportOperator before use.
>##E TFSR 000019 17:59:20(005) <main_program> Could not check all operators because of previous error(s)
>##E TCOS 000029 17:59:20(006) <main_program> Creation of step finished with status = FAILED
Can I pls know what is setting filename in APT_FileImportOperator ?
Pls help me how to proceed in this regard.
Thanks!
Using file pattern option in the sequential file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 26
- Joined: Fri Jul 13, 2007 6:33 am
Using file pattern option in the sequential file
V.Sarat Srinivas
Re: Using file pattern option in the sequential file
Check if there are any files with .txt extension available or not, that seems to be the problem. And, hope you are not specifying a path on your client machine, the URL has to be for a server directory.Couldn't find any files on host with pattern "*.txt".
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.
-
- Participant
- Posts: 26
- Joined: Fri Jul 13, 2007 6:33 am
Re: Using file pattern option in the sequential file
[/quote]
Check if there are any files with .txt extension available or not, that seems to be the problem. And, hope you are not specifying a path on your client machine, the URL has to be for a server directory.[/quote]
Hi Sud,
Thanks for the reply!
There are .txt files in the path specified and the system I am presently working this job is the server system itself,and I gave the path of the same windows machine.
Check if there are any files with .txt extension available or not, that seems to be the problem. And, hope you are not specifying a path on your client machine, the URL has to be for a server directory.[/quote]
Hi Sud,
Thanks for the reply!
There are .txt files in the path specified and the system I am presently working this job is the server system itself,and I gave the path of the same windows machine.
V.Sarat Srinivas