Unable to pick latest CSV file via File Writer Transformation

[Babloo]

I have updated (just the data for one field) one CSV file in the UNIX server and that file should be read by File Writer transformation.But for some reasons, file writer transformation taking only the old file as I could see only the data from the old file in the resultant dataset.What would be likely cause for this issue?

[Kurt_Bremser]

Inspect the log to see which file was read and which dataset was written. See Maxim 2.

[Babloo]

Filename is same and the log also telling the same. I just changed the data
without changing the file name. Dataset was created from the same file. I
want to know why the file which I updated is not being read by file writer
transformation.

[Kurt_Bremser]

Look at

• the modification times of the file and the dataset as represented by the operating system
• the timestamp(s) in the log

to see if the file timestamp < log timestamp <= dataset timestamp. Only then can you expect the dataset to change.

How do you view the dataset? Maybe that needs closing and re-opening.

[Kurt_Bremser]

Ummm, wait!

Are you really using the File Writer transformation? That creates a csv or other external file from a dataset, not the other way round. Changes in the csv will simply be overwritten with the unchanged contents of the dataset.