Deploying to Posit Connect with a local source package

Is there any way to deploy content to Posit Connect that uses a package installed from source locally? In this case it's a shiny app and I'm using renv for environment management. I have tried

  1. Putting the tarball in the project directory and installing it with renv::install("path_to.tar.gz"). In this case I get:
    ! All packages must be installed from a reproducible location.
    ✖ Can't re-install packages installed from source: square.
  2. Putting the tarball in renv/cellar and including that in the appFiles argument to rsconnect::deployApp(). But then when I try to deploy the app it looks for the package on Posit Package Manager, doesn't find it, and then the deployment fails.

I have seen another post with a similar question from a few months ago, but it's not clear from that exchange whether using a local package is possible, or whether the answer is basically "put that package somewhere else".

The post that you linked really does cover the options, and as you said, it more or less comes down to "put that package somewhere [that Connect can access]". There are some more details and explanations in the docs here: https://docs.posit.co/connect/user/publishing-packages.