...
It is important that the Excel files be closed and not open for editing before the load process begins. When the data load begins if the file is open then the process will error out. The file upload will can be uploaded as and when needed. After the file upload is complete, the information will be processed and saved thru ETL to save a person with its current department so that in the future we can saved to a table. The ETL job will then process the data in the table, linking a person to its current department. That data then can be used to create reports with employees and the departments they were associated with at the time.