cancel
Showing results for 
Search instead for 
Did you mean: 

Capture flat file date

Former Member
0 Kudos

Hi,

I am getting a text file every Monday on windows server 2008. When it is uploaded, the text file will be showing a date on its name as well as in the description (time and date of loading the file on windows system). I need to capture the date either on the name (For example - xyx_011612.txt.) or from the description.

This date has to be captured in a DI column. SYSDATE function will capture only the date of run rather than the date of file.

Appreciate your help.

Thanks,

Arun

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Problem Solved.

Arun

Former Member
0 Kudos

Arun,

How did you achieve this?

Former Member
0 Kudos

Hi Sandeep,

Double click the flat file in the dataflow and it will open the file in editor. On the left hand side, you see an option called Source Information. In the Source Information, select include file name in the column and it will display the file name in a seperate column.

Arun