Reece Walsh on 14 Nov, 2017 02:50 AM
Thank you for contacting Octopus Deploy support in regards to this query,
Whilst defining your release process, you are required to specify the package that contains the DACPAC file in the Deploy Package step, this is then referenced within the standalone step for the SQL-Deploy DACPAC template.
As long as the package exists within your Library it will be findable via "Package ID". I've attached some screenshots for visual aid if needed.
The SQL-Deploy DACPAC step identifies the relevant package step via "DACPAC Package Step Name". You must also specify the DACPAC filename itself under "DACPAC Package Name" since the DACPAC file resides within the package Octopus cannot retrieve this value.
Additionally, I've found an online example of another Octopus User deploying a Database Project DACPAC.
If you require any additional information or clarification please let me know :)