SSIS Package assessment Uisng Data Migration Assistant

Nikhil Jha 1 Reputation point
2020-09-09T13:05:49.887+00:00

We have successfully created a small SSIS package that extracts data from CSV and stores it in the SQL Server database.
The next task is to carry out an assessment of the Integration Services using the Data Migration Assistant.
I am following https://learn.microsoft.com/en-us/sql/dma/dma-assess-ssis?view=sql-server-ver15
article for the same.
But, when we carry out the assessment we are receiving errors. have attached a screenshot for the same.

23532-dma-error.png

The issue is in two folds:

  1. What is the exact path of the SSIS package that is to be provided
  2. The DMA only lists out SSISDB database among the others

Please guide on the issue.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,816 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,460 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Monalv-MSFT 5,896 Reputation points
    2020-09-10T02:38:05.533+00:00

    Hi @Nikhil Jha ,

    May I know if the path of File System: Integration Services Project4 and Azure server are in the same Server?

    If not, please copy the whole SSIS project folder into the Azure server.

    Or we can deploy SSIS projects to Azure SSISDB, please refer to Tutorial: Deploy and run a SQL Server Integration Services (SSIS) package in Azure.

    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.

  2. Monalv-MSFT 5,896 Reputation points
    2020-09-15T02:46:18.263+00:00

    Hi @Nikhil Jha ,

    It seems that we cannot migrate SSISDB database to Azure SQL Server.

    May I know if you create SSISDB in Azure? If not, please create it in Azure.
    On the Deployment settings page of Integration runtime setup pane, you have the options to create SSISDB and or Azure-SSIS IR package stores.

    Please refer to Create an Azure-SSIS integration runtime in Azure Data Factory.

    And then we can migrate SSIS projects/packages from the source SSISDB hosted by SQL Server to the destination SSISDB hosted by Azure SQL Database.
    Please refer to Redeploy SSIS packages to Azure SQL Database with Azure Database Migration Service.

    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.

    0 comments