I have a macros that loads stored procedures into staging and then loads it from staging to ods. I do some mapping checks with the fields in ods and staging, if there is an issue I create an error with the message tool.
I am trying to make the load more robust, if there is an issue with the mapping and I get an error it needs to go and update the Load_Flag in the DB to 0 so if I rerun the workflow it won't load that stored procedure and the batch can continue.
The excel file is the input for the macros, where I get the name of the proc and the load_flag. It is actually a sql table and not a excel file.