Deploying SQL Server Integration Services (SSIS) packages with Octopus

Shawn Sesna's article explores the automation of deploying SQL Server Integration Services (SSIS) packages and SQL Server Reporting Services (SSRS) reports using Octopus Deploy, highlighting how these supporting components can be incorporated into traditional application deployment processes. Typically managed manually by database administrators or integration specialists, particularly in production environments, Sesna demonstrates how to automate these tasks by building SSIS projects using Visual Studio and SQL Server Data Tools (SSDT), followed by packaging and deploying the resulting artifacts. Despite the lack of out-of-the-box support for building SSIS projects in most build servers, Sesna provides guidance for configuring Azure DevOps, TeamCity, and Jenkins to perform these builds. The process includes packaging the .ispac files into a supported format and pushing them to a repository before configuring an Octopus Deploy project to automate the deployment. By using a worker instead of installing an agent on the SSIS server, the deployment is streamlined, allowing for the deployment of these components alongside typical application deployments, thereby simplifying and enhancing the DevOps process.