Run dtsx packages stored on Dev Ops

Dom 646 Reputation points

We recently installed Azure Dev Ops for version control for our SSRS reporting. We store all our rdl files out in the repos and it is working fine.

We thought we could do the same thing with our dtsx packages from an SSIS project. We pushed all the files out there and everything is synched. However, we are not able to "execute" these packages in VS. When you right click on a package that is stored in the local file system, there is an "Execute" command (or you can click the green arrow button in the tool bar). This option is not available when you right on a package that is stored in the Azure Repos. We want version control for our package files and want them to be shared by different developers but need to be able to execute them from VS. Is there something we need to add to our Dev Ops or VS installation to make this possible?

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
3,777 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Anna Xiu-MSFT 18,716 Reputation points Microsoft Vendor

    Hi @Dom, 

    Welcome to Microsoft Q&A! 

    Do you mean that the “Execute Package” is missing when right-clicking on the Package.dtsx?

    User's image

    I tested on VS2022 and cloned a repo from the Azure DevOps. The “Execute Package” option is available. 

    Please create a new SSIS project and check that it works normally.

    If I misunderstand, please share us more detailed information or screenshots. 



    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 
    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.