SSIS Package Development Case Study for Duplicate Invoice Analytics

One of the controls that are checked during an account payable audit is whether there have been any duplicate payments made to the same vendor for a particular service or product delivered to the company over the course of a period. Since the payment process in the organization is all automated in the ERP system, the way to check this is to download all the payment data from the system and perform data analysis in order to see whether there had been any cases of payment made to the same vendor for a particular invoice (based on invoice number, date and amount). In order to monitor these exceptions on continuous basis, the Internal Audit will automate this data analysis process using the Microsoft SQL Server Integration Service (SSIS) tool and let it run periodically on monthly basis.