Blog Post

SQL Server Integration Services (SSIS) Blog
1 MIN READ

Migrate on-premises SSIS jobs to Azure Data Factory

Chunhua's avatar
Chunhua
Icon for Microsoft rankMicrosoft
Apr 09, 2020

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.

 

Published Apr 09, 2020
Version 1.0
No CommentsBe the first to comment