I'm attempting (relatively inexperienced) to write a Dockerfile that publishes a dacpac to a linux container before firing up sqlserver, but building the Dockerfile always results in the following: /bin/sh: 1: /home/mssql/localtools/sqlpackage: not found

below is a snippet of my Dockerfile (omitted some boilerplate for brevity)

FROM mcr.microsoft.com/mssql/server:2022-latest AS base

build/publish etc
FROM mcr.microsoft.com/dotnet/sdk:6.0 AS build

# https://learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-download?WT.mc_id=DT-MVP-4025156&view=sql-server-ver16
RUN dotnet tool install --tool-path ~/localtools microsoft.sqlpackage
#RUN dotnet tool install -g microsoft.sqlpackage

ARG CONFIGURATION=Release
WORKDIR /src
COPY . .
RUN dotnet build "SomeName.Database.sqlproj" -c $CONFIGURATION -o /db/build -v diag

FROM base AS final
COPY --from=build "/db/build/SomeName.Database.dacpac" "/tmp/SomeName.Database.dacpac"

# Launch SQL Server, confirm startup is complete, deploy the DACPAC, then terminate SQL Server.
# See https://stackoverflow.com/a/51589787/488695
RUN ( /opt/mssql/bin/sqlservr & ) | grep -q "Service Broker manager has started" && ( echo "SQLServer started" && sleep 10s ) || ( echo "SQLSERVER failed to start" && exit )

RUN ~/localtools/sqlpackage \
    /Action:Publish \
    /TargetServerName:. \
    /TargetDatabaseName:SomeNameDB \
    /TargetUser:sa \
    /TargetPassword:$MSSQL_SA_PASSWORD \
    /SourceFile:/tmp/SomeName.Database.dacpac \
    && pkill sqlservr

I've tried specifying the local tools path via dotnet tool install --tool-path ~/localtools microsoft.sqlpackage but to no avail

UPDATE

The file now looks as follows but now getting #0 21.67 SQLServer started #0 31.68 /bin/sh: 1: /tmp/sqlpackage/sqlpackage: Permission denied

FROM mcr.microsoft.com/dotnet/sdk:6.0 AS dacpac-build
ARG CONFIGURATION=Release
WORKDIR /dacpac
COPY . .
RUN dotnet build "SomeName.Database.sqlproj" -c $CONFIGURATION -o /build -v diag
RUN dotnet tool install --tool-path /localtools microsoft.sqlpackage

FROM sql-server AS final
COPY --from=dacpac-build /localtools /tmp/sqlpackage/sqlpackage
COPY --from=dacpac-build "/build/SomeName.Database.dacpac" /tmp/SomeName.Database.dacpac

RUN ( /opt/mssql/bin/sqlservr & ) | grep -q "Service Broker manager has started" && ( echo "SQLServer started" && sleep 10s ) || ( echo "SQLSERVER failed to start" && exit ) && \
    /tmp/sqlpackage/sqlpackage \
    /Action:Publish \
    /TargetServerName:. \
    /TargetDatabaseName:SomeNameDB \
    /TargetUser:sa \
    /TargetPassword:$MSSQL_SA_PASSWORD \
    /SourceFile:/tmp/SomeName.Database.dacpac \
    && pkill sqlservr