I can see nothing in the links which you provided which states that ispac files (which are the result of building an SSIS project) can be deployed to the file...

Do you have SQL Server Developer Edition installed? That should be sufficient.

Something like this should get you most of the way there:

WITH Results
AS
(
  SELECT
    UPPERAGE
  ,  [First trail year] = CASE

So are you trying to connect as a SQL Server named user, by passing username and password credentials?

Any time that an SSIS job works in SSDT, but not in SQL Agent, your first suspicion should be that there is a permissions problem.
Does the SQL Agent service/proxy...

Hello Scott
I won't download the solution just yet, because I believe I understand the issue you are having.
As I cryptically implied in my earlier message, configuration of data...

If you are working with project-level parameters and connections, your packages need to be deployed to SSISDB.
Once you have this, use SSISDB environments to configure your connections per environment.