Using file pattern option in the sequential file
Posted: Tue Aug 28, 2007 6:42 am
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!
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!