Loading csv file name into a MS SQL table

[MaxIT]

I need to load data from different csv files into a MS SQL table.

I'm already able to add an additional column with the Load Date as GETDATE().

I'd like to load the csv File Name as well.

Any idea?

Thanks

[manodwhb · Accepted solution]

@MaxIT , if you are using tfilelist to list the files and iterate file by file then in tmap or in tJavarow you can use the global variable  of tfilelist.

((String)globalMap.get("tFileList_1_CURRENT_FILE"))

[MaxIT]

It works with the tMap.

Thanks