I have to merge some data from a file that can be created or not in the directory. That means that if the file exists I have to use it in a merge transformation defined in another table. The problem is that if file doesn’t exists, the merge transformation goes in error and execution of the project halt with error.
Is there a way to condition the merge transformation only if the table exist? Probably the best way should be to condition the importation of the cv file, creating an empty table with last used structure (number and name of the column). Any other solution?