Not sure whether I can use this new feature for the task I had in mind.
Currently I have several environments, and the Octopus server has access to the database servers of all environments.
I have SQL management tools installed on the Octopus server.
I would like to move the tenticles from the DB servers onto the Octopus server so that it deploys the Dacpac files to each environment.
The NuGet package includes a set of Dacpacs, and also a deploy.ps1 file which uses Octopus variables to deploy to the relevant environment.
Is it possible to get the task executed from the Octopus server for each environment that the project deploys to?