SQL-Deploy DACPAC

[sai_sandeep_edpuganti]

Hi,

Getting below error when using SQL - Deploy DACPAC step. the deployment target machine running this step has latest power shell version 4.0 and .NET Framework 4.5.

Could not find the file: Microsoft.SqlServer.TransactSql.ScriptDom.dll
The remote script failed with exit code 1

The SQL DATABASE Project created using VS 2015, Target SQL server version is sql server 2014.

The dll is present on server: C:\Program Files (x86)\Microsoft SQL Server\130\SDK\Assemblies\it, C:\Program Files (x86)\Microsoft SQL Server\110\SDK\Assemblies

Please advice.

Thanks!!

[Alex.Rolley]

Hi,

Thanks for getting in touch!

So that we can investigate further can you please let me know which version of Octopus you are using, as well as which operating system your SQL Server is running on. At this point the issue looks environmental (in that there is a problem with the DLL), looking around I found this support page which looks to have some good troubleshooting steps for this issue.

If you can try the steps outlined on the linked page and let me know how you get on that would be greatly appreciated,

I look forward to hearing from you!

Regards,
Alex

[sai_sandeep_edpuganti]

@Alex.Rolley

n

Hi Alex, I will go through your link. Here are details you asked.

Octopus 3.12.4,
Tentacle is on Windows server 2008 R2 Standard
SQL Server:Windows Server 2012 R2 Standard