Visual Studio 2019 and Azure Devops Pipeline Build Failed

PowerBI82 21 Reputation points


I recently installed Visual Studio 2019 and have a database project I am working on which I have cloned the Repository from Azure Devops Repos.
I created a test table on the project and then pushed and committed the changes just to make sure it appears on my branch, I then deleted this table and pushed and committed the changes to the branch as it was a test table and not required.

I then amended an existing view to add a new column, I pushed and committed the changed to the branch.

I then went to Azure Devops and created a Pull Request and this was completed.

I then went to the Pipelines and ran an an existing Build Project.
This where it failed with the error message:

2021-01-28T17:02:42.4303138Z ##[error]D:\a\1\s\Database Projects\NEWReporting\NEWReporting\DW Tables\Adm\Table1.sql(0,0): Error SQL72001: File "D:\a\1\s\Database Projects\NEWReporting\NEWReporting\DW Tables\Adm\Table1.sql" does not exist.

Not sure why it is still referencing the table "Table1.sql" as this is deleted from the Project on Visual Studio?

Any Ideas

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,469 questions
0 comments No comments
{count} votes

Accepted answer
  1. Dave Patrick 426.2K Reputation points MVP

    Devops / TFS is not currently supported here on QnA. The product group for Azure DevOps / TFS actively monitors questions over at

    --please don't forget to Accept as answer if the reply is helpful--

    0 comments No comments

0 additional answers

Sort by: Most helpful