Migrate On-Prem SSIS to Azure

Job ID: 39724260

Budget: ₹400 – ₹750 INR

I need your help moving a complete library of on-prem SSIS solutions into the Azure environment. The workload includes every class of package we run—data transformation, ETL, and straight data-loading jobs. This is a pure lift-and-shift: keep the packages exactly as they are; no redesign, no added logic.

Target platform
• Run-time: Azure Data Factory with SSIS Integration Runtime
• Storage & compute: Azure SQL Database for metadata and target tables, Azure Blob Storage for stage files

Python will be the glue. I want portable scripts that extract the packages from SSISDB, provision the Azure SSIS IR, deploy the dtsx files, update connection managers where needed, and trigger test executions so we can compare row counts and hash totals to the on-prem run.

Deliverables
• Well-documented Python automation (ideally using pyodbc / azure-identity / azure-mgmt-datafactory)
• Deployed and validated packages in ADF, visible in the monitoring blade with successful status
• A concise run-book covering setup, rollback, and rerun procedures

Everything will be handed off through Git so that my DevOps pipeline can reuse your work. When the last package executes in Azure with identical results to production, the job is done.