Share via

Error while doing assessment using DMA tool

Nilesh Patel 111 Reputation points
2021-12-10T05:11:29.747+00:00

Getting error while doing assessment using DMA tool for choosing assessment type as Integration services.

Attaching the screenshot for the steps how I am proceeding and attaching the error message.

![156488-overview1.png][2] [2]: /api/attachments/156488-overview1.png?platform=QnA
156664-error-assessment.png

Azure Database Migration service

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 35,506 Reputation points MVP Volunteer Moderator
    2021-12-11T21:17:05.017+00:00

    To move your existing SSIS packages and projects to Azure and use them with Azure SQL and Azure Managed Instance you need to read this documentation.

    To assess SQL Server Integration Service(SSIS) packages, below components need to be installed with Data Migration Assistant:

    • SQL Server Integration Service with the same version as the SSIS
      packages to assess.
    • Azure Feature Pack or other third party components if SSIS packages to assess have these components.

    DMA needs to run with administrator access to assess SSIS packages in Package Store.

    Please read this documentation for more information.

    I answered this question for you yesterday (December 10th) at StackOverflow as you can see here.

    Was this answer helpful?

    0 comments

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.