Azure Data Factories vs SSIS

The answers to this old post are quite outdated. My comments below are related to ADF version 2.

First of all, ADF has the capability to run SSIS packages, so moving your legacy ETL processes there and moving to ADF incrementally is not only possible but recommended. You don't want to change everything with every new piece of technology that comes out. You can then only implement new or modified ETL processes on ADF activities.

Secondly, although maybe not completely there yet, with ADF dataflows you can do transformations you can do with SSIS. There are still some missing bits and pieces, but most of the commonly used functionality is there.

ADF authoring does not require Visual Studio. It does need specific skills but I found the learning curve not to be steep. Documentation and best practices are still a bit lacking in certain areas, but someone already experienced in database / data warehouse architecture and ETL will find it relatively easy. The best thing about it is that most things can be done visually without messing with the code (which is just simple JSON).

Furthermore, ADF integrates with Azure Devops and uses Git for versioning. So you get change management for free.

For the more advanced needs you can also run Databricks activities with Java (Scala) or Python, integrate with Hadoop (Hive and Pig) and Spark.

Finally, ADF incorporates monitoring and diagnostic tools which in SSIS you had to build yourself. You can see much more easily which activity failed and what the error was.

If your ETLs are simple and easy to convert-replace with Data Factory.If they required complex logic, use SSIS.
In other words, if the transform logic can be implemented by configuration, Data Factory is the best. If it required writing code and programming skills, SSIS is the right tool.

A few links that may help other people(you most likely made you decision already)

"Azure Data Factory and SSIS compared"

Think of ADF as a complementary service to SSIS, with its main use case confined to inexpensively dealing with big data in the cloud.

Download Azure_Data_Factory_vs_SSIS article from sqlbits

ETL is Extract Transform and Load, while ADF does not transform anything (with ADF you can transform via using SQL Statement or Proc, but in ETL basic extraction logic are out of the box).

If you want to choose one out of them, its totally depend on your requirement.

• If Transformation Logic is complex use ETL

• If you are playing with huge data go for ADF

• ADF charge as per your usage, but SSIS come with license.

• If your data is in On-Premises, I would suggest you to go with ETL

• Performance of ETL is totally depend on your on-premises machine
  configuration, while for ADF you don't have to worry about the
  performance.