Lately I’ve been working on a deployment process for Integration Services Projects that makes use of the views and stored procedures in SSISDB to deploy folders, variables, ispacs etc etc. The reason why I’ve gone this route instead of any of the others is so that I can just use Sql Data Client dll which is part of .NET. So no extra moving parts required when deploying.

And as part of the deployment I want to run the validate project stored procedure. This is the blurb for what validation does: