syntax error when deploying DBUP script through octtopus

98 Views Asked by At

I have DBUP scripts in the .Net Frameowrk4.5 project. For some reason when deploying the project through octopus, I get the below syntax error. This works ok on the local SQL server.

This is script

enter image description here

I get below error

enter image description here

1

There are 1 best solutions below

1
Twerthi On BEST ANSWER

This looks like it could be an encoding issue, is the language encoding of the embedded .sql file different than the OS language selection of the server?