okay so in SSIS there is was a package where in a so since it is a pharmacy based project so how it happens every week we get new medicines into our system okay and so for example we have a hundred insurance plans in our system so it is very difficult for us to ask the user or for them to give something to map those new medicines to those insurance plans and and in the beginning they also might not know that okay this insurance plan should cover this thing because a single client also cannot take all the decisions so what we used to do whatever new medicines comes to the system we used to map all the new medicines to all the health insurance plans then user used to update those into the screen and it goes to a hierarchy of approvals okay so there were ten hierarchy of approvals required so after a certain hierarchy of approvals we had to run multiple REST API action methods because after each action method we had to send data to a certain third-party vendor because to get their approvals okay and to let them know in a in a file format okay this is how it will be done so there were multiple six to seven API calls then after those API calls so there were certain multiple API calls to update data in our system then there were certain then we were sending the flat file information to third-party vendors to tell them okay this is how we have mapped the new medicines to the health insurance plans and it is in this hierarchy of approvals so do you want to approve it or not then we used to read those flat files and again call our REST action methods to update that part in our system so that we can view it over the screen it was a very complex process we for error handling part I we used event handling because REST API is calling REST APIs or fetching data from REST APIs sometimes they can be failures so for that we did error handling that in case if there is an error it should retry it at least three times then it can fail in case of flat file like there is some we are getting some error while reading some data from a flat file we were using the error outputs feature and we were sending that to error output where and again we were using a logging table in our database and then we used to run a stored procedure also that okay if something new is added into the logging database we we wrote a stored procedure how we need to handle that so we don't miss those error out records so this is how we did the error handling part