Share via

SSIS Packages Migration

puri puri 20 Reputation points
2026-02-16T17:02:05.1066667+00:00

Hi

Can anybody guide on exact steps and share links maybe Youtube links and Microsoft Documentation link for below:

SSIS Packages migration from on premises to Azure Sql Managed Instance.

SQL Server Integration Services
0 comments
Answer accepted by question author
  1. Akhil Gajavelly 1,570 Reputation points Microsoft External Staff Moderator
    2026-02-17T10:45:01.2533333+00:00

    Hi @puri puri ,

    You have only two practical ways to do this.

    Using Azure database migration service (DMS)

    • Keep packages in SSISDB (Project model) on-prem.
    • Create managed instance.
    • Create Azure data factory + azure-SSIS integration runtime (mandatory).
    • Create DMS project - source: SQL server - target: managed instance - SSIS migration run.

    Best for bulk migration. Manual deployment

    • Build project - generate .ispac.
    • Deploy to SSISDB in managed instance using SSMS.
    • Configure Azure-SSIS IR.
    • Test and schedule.

    Better for small setups / more control.

    Important: Managed Instance alone cannot run SSIS. Azure-SSIS integration runtime is required in both cases.

    Thanks,
    Akhil.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Q&A Assist
    2026-02-16T17:02:19.7466667+00:00
    AI generated content. This question contains an answer created with AI from Q&A Assist. Learn more

    To migrate SQL Server Integration Services (SSIS) packages from an on-premises environment to Azure SQL Managed Instance, you can follow these general steps:

    1. Assess Your SSIS Packages: Before migration, evaluate your existing SSIS packages to ensure compatibility with Azure SQL Managed Instance.
    2. Convert Older SSIS Packages: If your SSIS packages are from a version earlier than 2012, use the Integration Services Project Conversion Wizard to convert them to the project deployment model. This can be done using SQL Server Management Studio (SSMS).
    3. Create an Azure Database Migration Service Instance: In the Azure portal, create an instance of Azure Database Migration Service (DMS).
      • Go to All services, search for Azure Database Migration Service, and select it.
      • Locate your instance and create a new migration project.
    4. Specify Migration Project Details: In the migration project, specify the source server type as SQL Server and the target server type as Azure SQL Managed Instance. Choose SSIS package migration as the type of activity.
    5. Provide Source Details: Enter the connection details for your source SQL Server. If necessary, check the option to trust the server certificate.
    6. Execute the Migration: Follow the prompts in the Azure Database Migration Service to complete the migration of your SSIS packages to Azure SQL Managed Instance.

    For more detailed guidance, you can refer to the official Microsoft documentation on migrating SSIS packages:

    Unfortunately, I cannot provide YouTube links, but the Microsoft documentation contains comprehensive steps and guidance for the migration process.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.