Hi
I have files in remote location. these files are inserted daily.
after that i run the ETL job to process these files.
I used ftp to get the files form remote location to datastage location.
but i want to process only NEW files daily.
IS THERE ANY FTP command which do .
please share your thoughts
thks
ftp
Moderators: chulett, rschirm, roy
How do you identify the new files?
Do the files get overwritten everytime?
Does the file name remain the same or do you rename them with the datetime?
If you can have a fixed name for the file all the time, or you can have a script that renames the new file before you do the ftp then you will be fine.
Do the files get overwritten everytime?
Does the file name remain the same or do you rename them with the datetime?
If you can have a fixed name for the file all the time, or you can have a script that renames the new file before you do the ftp then you will be fine.
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.
Better to store them in a database table... then pull them into a hashed file to use for checking in the actual process run.
Do you have the permissions you'd need to delete files from the ftp server? If so, you would just issue a del command inside the ftp session - your scripted ftp session.
The only way to do something like this using the dreaded FTP stage is via the before or after Telnet command options... and just because you can ftp to a server doesn't imply that you can also telnet to it.
Do you have the permissions you'd need to delete files from the ftp server? If so, you would just issue a del command inside the ftp session - your scripted ftp session.
The only way to do something like this using the dreaded FTP stage is via the before or after Telnet command options... and just because you can ftp to a server doesn't imply that you can also telnet to it.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers