In trend with CI/CD, and not only because of the trend, we have a TFS build pipeline and a release pipeline. We deal with on-prems SSIS and most of our deployments mean deploying a SSIS solution and changes to one or more databases, via a Database project deployed as a dacpac package.
The way I work is to test locally from VS, both the ETLs and the database project deployment.
The way I work is to test locally from VS, both the ETLs and the database project deployment.
Recently, however, I tested the ETLs and the DB deployment to a server, as usually. I encountered an error that I initially thought is about the collation of the database: "The project and target databases have different collation settings. Deployment errors might occur." - and deployment errors did occur, as seen below.
Banging my head on the wall for a bit, until I read carefully the error message, saying that "Deployment errors might occur". Which means this is not the real error. Oh, yes, so I started to look with a different eye, understood I that the pipeline was set to deploy to another database, than it was all very easy.
