Andy Leonard frames the discussion:
The conversation around SSIS is heating up again.
Some see the signals and conclude SSIS is on the way out. Others point to the strength of the ecosystem and say it is far from done. Both perspectives miss something important.
The introduction of Fabric SSIS public preview does not settle the debate. It reframes it.
I see this as another way of saying, “We know you’re still using SSIS packages but we really don’t want to invest in that any longer, so how about you move it into Fabric until you do finally rewrite things as Fabric Data Pipelines?”
That said, Andy lays out where he sees the current landscape and how there are common issues across Microsoft’s ETL/ELT products, mostly in how people use them.