I am working on a SSIS package which does the following -
1) Read data from an excel file placed in a shared location
2) Load the data in the database tables
3) once the data is successfully loaded, send an email notification and then rename the excel file as "Processed_Excel".
I have been successful in the 1st 2 steps and the 3rd one partially, but unable to figure out the part ie, rename the excel file to "Processed_Excel".
Moreover, is there any way of Exception Handling like "File Not Found". (For eg: in the 1st step if the excel file is not present in the shared location, then an exception is thrown and the execution of the package is terminated).
Thanks in advance.