Using Azure DevOps and PowerShell to automate testing of SSIS packages
28 May 2020

One of our customers aimed to modernize their on-premises project and replace the aging AS/400 system with Microsoft SQL Server. Having an enormous amount of code, the existing program was almost maintainable and cried for a smart solution. DB Best developed a brand-new way to manage epic projects. We required a smart solution to optimize costs and streamline the process. Our team leveraged the latest DevOps practices to create a solution that allows for managing the epic systems in layers. In this post, we will share the best practices of reducing human errors and the cost of delivery with the SQL Server Integration Services (SSIS) based con...