Skip to content

sqlpackage build fails when referencing external data (eg openrowset) #802

Description

@MagAlp
  • SqlPackage or DacFx Version:
  • "Microsoft.Build.Sql" Version="2.2.0" />
  • "Microsoft.SqlServer.Dacpacs.FabricDw" Version="170.0.4"
  • .NET Framework (Windows-only) or .NET Core:
  • Environment (local platform and source/target platforms):

Steps to Reproduce:

  1. Create a view that selects from OPENROWSET(...):
    CREATE VIEW [dbo].[article]
    AS
    SELECT

FROM OPENROWSET(
BULK '/edw/articles/Articles.csv',
FORMAT = 'CSV',
FIELDTERMINATOR = '0x01',
FIRSTROW = 2,
FIELDQUOTE = '')

  1. Create a stored procedure that selects from the view
    CREATE PROCEDURE eltArticle as
    BEGIN
    CREATE TABLE dbo.DimArticle
    AS
    SELECT
    [Id] AS BKArticleId
    FROM dbo.article
    ;
    END
  2. Build will fail with Build error SQL71501 unresolved reference to object

Did this occur in prior versions? If not - which version(s) did it work in?
This worked in 2.2.0-preview.2 and earlier versions
(DacFx/SqlPackage/SSMS/Azure Data Studio)

Activity

llali commented on Jun 22, 2026

@llali
Member

fixed in SDK 2.3.0-preview.1

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions