title: Invalid object name error: DACPAC Deployment using SQLPackage.EXE
body: <p>I’m facing an issue when deploying a DACPAC to a SQL server (SQL 2014 – 12.0.2430). Here’s the error I’m getting: invalid object name dbo.usp_SomeStoredProcedure_Update. </p>
  
  <p>This happens if I’m altering a stored procedure. Though, the DB project gets built successfully. I’m using VS 2013 Update 4 for building database solution.</p>
  
  <p>Here’s the command that I’m firing:</p>
  
  <p>“C:\Program Files (x86)\Microsoft SQL Server\120\DAC\bin\SQLPackage.exe” /TargetDatabaseName:DBName /TargetServerName:ServerName /Action:Publish /SourceFile:DBName.dacpac /p:IncludeTransactionalScripts=true /p:BlockOnPossibleDataLoss=false /p:DropIndexesNotInSource=false /p:GenerateSmartDefaults=true</p>
  
  <p>Any idea what might be happening?</p>