How to get timeStamp of a file and store it in a datatable column?

csv
studio

#1

Hi All,

How can I get a timeStamp of a CSV file and store it in the column of a datatable?

I would like to do following things:

  1. Read all records in CSV file and store it in a datatable.[Done using Read CSV activity]
  2. Add column called File TimeStamp. [Done using Add Column activity]
  3. Get file timeStamp and store it in a column created in 2nd step. [Help required]

Thank you!
Shyamal Dave.


#2

File.GetLastWriteTime(csv path).ToString will give the timestamp.

Why not pass the above value to DefaultValue in Add Data Column activity in #2 step.


#3

Ok. This works. Thanks vvaidya.