Invalid value for the "SqlTarget" parameter of the "SqlBuildTask" task.

[greg84]

• SqlPackage or DacFx Version: SqlPackage 162.1.172
• .NET Framework (Windows-only) or .NET Core: net 8
• Environment (local platform and source/target platforms): Windows

Steps to Reproduce:

1. Added the following line inside <Project> in my sqlproj file:

<Sdk Name="Microsoft.Build.Sql" Version="0.1.14-preview" />

2. Run dotnet build from the folder containing the sqlproj file.

Build fails with this error:

C:\Users\me.nuget\packages\microsoft.build.sql\0.1.14-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(546,7): error MSB4094: "D:\myproject\bin\Debug\mydatabase.dacpac;D:\myproject\bin\Debug\mydatabase.dacpac" is an invalid value for the "SqlTarget" parameter of the "SqlBuildTask" task. Multiple items cannot be passed into a parameter of type "Microsoft.Build.Framework.ITaskItem". [D:\myproject\bin\Debug\mydatabase.sqlproj]

[ErikEJ]

@greg84 Maybe you could share your .sqlproj file?

[greg84]

Fixed it by removing this line:

<Import Project="Microsoft.Data.Tools.Schema.SqlTasks.targets" />

Sorry, closing this ticket.

[dzsquared]

Thanks @greg84! You got it - removing the reference to those targets. The Microsoft.Data.Tools.Schema.SqlTasks item correlates to the previous SQL project format, the targets necessary for Microsoft.Build.Sql are automatically included for all platforms.