A repository containing code to archive SSISDB log tables. Managed by Tim Mitchell and Andy Leonard.
Since 2018, Tim Mitchell has shared A Better Way to Clean Up the SSIS Catalog Database. Please visit Tim's post to learn more about why his script is important - especially in enterprises using the SSIS Catalog to execute a large number of SSIS packages - especially if said SSIS packages generate copious amounts of log data.
In 2021, Andy developed the initial version of SSIS Catalog Archive. Tim and Andy met and agreed to keep Tim's SSIS Catalog Purge script and SSIS Catalog Archive open-source and synchronized. And here we are!
- Obtain a copy of the code.
- Follow the instructions in the document named SSIS Catalog Archive Documentation - version 0.pdf (or similar)