![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 56.00000000000001%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,024 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 46%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Migrating from ADF to SSIS is not a common scenario, and there isn’t a direct lift-and-shift solution available. The architectures of ADF and SSIS are fundamentally different, and they use different methods for data transformation and movement.
ADF is a cloud-based ETL tool that uses a wide range of connectors and activities for data movement and transformation. On the other hand, SSIS is an on-premises ETL tool that uses packages for data integration1.
While there are tools and guides available for migrating from SSIS to ADF, the reverse is not typically done and would likely require rewriting your pipelines in SSIS. This is because SSIS packages are more granular and procedural, while ADF pipelines are more declarative.
Before proceeding, I would recommend thoroughly evaluating the reasons for this migration and considering the effort it would take to rewrite your pipelines in SSIS. If you have complex pipelines in ADF, rewriting them in SSIS could be a significant undertaking.
