Migrate on-premises SSIS jobs to Azure Data Factory

This post has been republished via RSS; it originally appeared at: SQL Server Integration Services (SSIS) articles.

When migrating on-premises SQL Server Integration Services (SSIS) workloads to SSIS in ADF, after SSIS packages are migrated, you can do batch migration of SQL Server Agent jobs with job step type of SQL Server Integration Services Package to Azure Data Factory (ADF) pipelines/activities/schedule triggers via SQL Server Management Studio (SSMS) SSIS Job Migration Wizard.

In general, for selected SQL agent jobs with applicable job step types, SSIS Job Migration Wizard can:

  • map on-premises SSIS package location to where the packages are migrated to, which are accessible by SSIS in ADF.
  • migrate applicable jobs with applicable job steps to corresponding ADF resources.
  • generate Azure Resource Manager (ARM) templates in local output folder, and deploy to data factory directly or later manually.

For more information, see document page.

step3-1.png

 

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.