I am working with one of our teams to replace their ‘Deploy a Package’ step with a ‘Run a Script’ step (with referenced package) to run the project on a single worker.
Here is the test setup:
1. Download & Extract DACPAC Package
We want this script to perform an identical function of the “Deploy a Package” step.
Referenced Packages: GIEQ.TestDBScripts
Enabled to extract package during deployment.
2. SQL - Execute SQL Script with SQL or Windows Authentication
DACPAC Package Extract Step Name: Using the above “Download & Extract DACPAC Package” step.
In their current setup using “Deploy a Package” step, we see these results in the package extraction:
Deploying package: E:\Octopus\Tentacle\Files\GIEQ.TestDBScripts@S2021.1.22.1@E0E416AC37463341A6233837CEC94358.nupkg
Extracting package to: E:\Octopus\Tentacle\DEV\GIEQ.TestDBScripts\2021.1.22.1
Extracted 1 files
We want to avoid using a custom install directory–just the default. From what I can see, they do not specify the extraction location. In this case, because we are deploying to a worker, the default extraction location should be:
I’ve played around with a script, and see it being extracted to the work folder, but never to the applications folder.
Any help would be appreciated.