SSIS solution deploy

For a new data migration project, we have a SSIS SSDT solution with quite a few projects in it. Visual studio does not all to deploy all projects at once with a single mouse click. So I created a simple powershell script that does the job. It reads the .sln file, grabs each project and then pushes the .ISPAC file into the SSIS catalog. Also, it creates the catalog itself when required. I only use it to deploy to the dev box, but with some extra logging and options it could even be used within a CI/CD pipeline.

SSRS powershell deployment

Yet another post on this topic? Well yes, historically deploying -the now called paginated reports- was pretty much relying on the cumbersome RS.exe. Luckily Microsoft started a powershell based ReportingServicesTools github repo back in 2016. Which is quite an improvement, but still I wanted a fully fledged way to deploy reports based on the actual release build of my SSDT reporting solution. And guess what, turns out Tim Abell had already created an awesome project on that. It had a few shortcomings for what I wanted to get done, hence I forked the project, and added a few features such as:

  • Logging integration using ScriptLogger module
  • Log dump of reportfolder hierarchy
  • Caller script (DeploySSRSSolution.ps1) which will call the solution deploy
  • Remove of RDL/datasource which are no longer in the project
  • Hash compare of RDL files (OverwriteReports param)
  • Support for database based credentials on datasources

Eventually I will refactor it to make full use of the Reporting Services Tools from Microsoft.

Check it out here: