Advantages of using an ETL tool over Stored Procedures in any DB

• Easier to maintain the code – through atomicity and simpler interfaces
• Many reusable components – a lot of code (e.g. Lookups) has already been constructed
• More flexible than SPs – they have more functionality (e.g. Cached Lookups, FTP)
• Can deliver better performance than SPs – use of In Memory techniques can boost performance
• Features such as logging/audit and metadata are built in
• Support is more broadly available – it’s easier to find out why a prebuilt, widely used component is throwing errors