Database Project reference Error

• krishnasavalia

  SSC Veteran

  Points: 230

  More actions

  November 30, 2014 at 7:35 am

  #292973

  Hi,

  I have my databases in TFS project with all references. But during the Deployment from dacpac, I am getting below error for some reference. Issue is that it's converting dot(.) to pipe(|) during the automatic deployment.

  If I change the reference property option COPY LOCAL to "TRUE", it will fix the error but I am concern about changing that option. We don't want to do that.

  Anyone come across this error? I am trying to find it on google but so far no luck.

  Error SQL0: The reference to the external element with the name '[$(Database)]|[dbo].[Table1]' could not be resolved. No such element exists.

• naicker.kreagan

  SSC Rookie

  Points: 39

  More actions

  July 27, 2016 at 5:28 am

  #1892226

  Hi.

  Did you ever come right with this problem?

  I've got the exact same issue and i've set my "COPY LOCAL" variables to TRUE for both my Database Reference objects.

  I've also ensured that all DACPAC's exist in a single folder before executing the release.

  Any advise would be welcome.