Hi,
I have a file to process that file has a filename as filename_date.csv
I need to pass that date in the job is there anyway to do this.
If so please let me know.
Thanks
reading date from the file name
Moderators: chulett, rschirm, roy
chulett wrote:Please explain precisely what "I need to pass that date in the job" means. ...
In Sequential file stage you have "fileNameColumn" property.ravi_etl wrote:Hi,
I have a file to process that file has a filename as filename_date.csv
I need to pass that date in the job is there anyway to do this.
If so please let me know.
Thanks
Read the help available.
Code: Select all
Adds a VarChar (Unicode for NLS installs) column to the output that contains the name of the file that the record is sourced from. User must add this column definition to the output columns to prevent it from being dropped if runtime column propagation is unchecked
-
- Participant
- Posts: 33
- Joined: Mon Nov 12, 2007 1:02 am
- Location: Bangalore
Re: reading date from the file name
Do you need to parse out the date from the filename? You want to do that using a sequence? job? or script?ravi_etl wrote:Hi,
I have a file to process that file has a filename as filename_date.csv
I need to pass that date in the job is there anyway to do this.
If so please let me know.
Thanks
Rishabh Sagar V
Bangalore
Bangalore
I asked because I'm not that much into guessing what the problem or question might be anymore, and would prefer people learn how to ask for help.
Always make sure your question / issue is clear and you've attempted to provide enough information so that (ideally) people can get right to the 'solving' part and we don't end up with multiple back-and-forth exchanges for clarifications or chasing of the wild geeses.
Always make sure your question / issue is clear and you've attempted to provide enough information so that (ideally) people can get right to the 'solving' part and we don't end up with multiple back-and-forth exchanges for clarifications or chasing of the wild geeses.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers