File Processing using tFileList

[GivenM]

Im using tFileList to load all the files in the directory using a wildcard i.e

tFileList---->iterate---> tFileInputDelimited----->Main--->tMap----->Main--->tMSSqlOutput

wildcard on the tFileList is filemask "cusageFin*.csv"

I have MSSQL table that has filename field to store the file name of that is loaded, however i want to be able ensure that i do not load the same file twice as i run my job. How do i make sure that i will not load the same file loaded each time i execute my job

[Anonymous]

Hello,

If we understand your requirement very well, you could make use of the setting "Action on data" to "Insert or update on duplicate key or unique index" in your tMysqlOutput

Let us know if it is what you are looking for.

Best regards

Sabrina