Capture flat file date

[Former Member]

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

[Former Member]

Problem Solved.

Arun

[Former Member]

Arun,

How did you achieve this?

[Former Member]

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