As per my requirement we use NAS drive to load data from excel to our tables. Once scheduled jobs and data is inserted into target table using transform maps then we will push the file to Archive folder. Now my requirement is if by any chance they put file in wrong format or wrong file name. I need an notification to be sent out to few of our BA recipients
