FTP files from UNIX server to DataStage server
Posted: Mon Jun 01, 2009 12:28 am
Hi All,
I have a requirement to FTP a set of csv files from SFTP server to DataStage server.
Requirement detail is below-
When DataStage job lunched-
1) DataStage job should check for complete set of csv file. Each set of files will be named with prefix of 'YYYYMMDD_ as follow
a)YYYYMMDD_file1
b)YYYYMMDD_file2
c)YYYYMMDD_file3
And if completed set of file present , proceed, otherwise check at a 5 minute interval to check whether a complete set of files exixts. If job run for 60 minutes and complete set of file not present, Job should terminate.
After identifying complete set files for processing file should be copied to DataStage server via SFTP from ftp server.
Thanks in advance,
Santosh.
I have a requirement to FTP a set of csv files from SFTP server to DataStage server.
Requirement detail is below-
When DataStage job lunched-
1) DataStage job should check for complete set of csv file. Each set of files will be named with prefix of 'YYYYMMDD_ as follow
a)YYYYMMDD_file1
b)YYYYMMDD_file2
c)YYYYMMDD_file3
And if completed set of file present , proceed, otherwise check at a 5 minute interval to check whether a complete set of files exixts. If job run for 60 minutes and complete set of file not present, Job should terminate.
After identifying complete set files for processing file should be copied to DataStage server via SFTP from ftp server.
Thanks in advance,
Santosh.