SSIS Source Control Azure Dev Ops Git repo help

ApplebyNick-0083 1 Reputation point
2020-09-08T07:36:34.57+00:00

HI All.
I have recently moved an SSIS project from VSTS into an Azure DevOps git repo.
The project is a simple one with a master package calling several child packages using "Execute package Task " with reference type = "Project Reference"
The project itself was set up to use project deployment method.

Now it is in the DevOps repo, when I open SSDT in visual studio, all of the references within the master package are returning errors and the only method way to see the references for the child packages is to change reference type = "External" then point to the file system path. This will obviously fail once I deploy to a server.

Any

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,453 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Monalv-MSFT 5,891 Reputation points
    2020-09-08T09:49:39.913+00:00

    Hi Appleby,

    If you change reference type = "External" in Execute Package Task, please copy the .dtsx files in the new server.

    Best Regards,
    Mona

    ----------

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.