SQL Server Stored Procedure and SSIS Package migration to Microsoft Fabric

[avishek_learner]

We have a requirement to migrate on-prem EDW - sql server stored procedures & SSIS packages to Microsoft Fabric. What would be the best solution approach for this? 

Microsoft Fabric does not provide an SSIS connector as of today, so would it be convenient to migrate the SSIS packages to Azure Data Factory and then from Azure Data Factory to Fabric Data Factory ?

Also what would be best solution approach to migrate the on-prem stored procs to Fabric Warehouse stored procs? Regards!

Tx......Avishek

[GraceGu]

Stored proc activity is already there in Fabric.

Run SSIS package, currently, only available in ADF.

For Fabric, you can vote on Fabric Idea: SSIS integration runtimes in Fabric Data Factory for the need. We are working on the experience to bring SSIS workloads in Fabric Data Factory. And will keep update on idea when we have concrete date to share. 

[DennesTorres]

Hi,

About the SSIS, I think you will have no choice but rewritting the packages as pipelines. Even if you migrate to Azure Data Factory, they will not integrate with Fabric.

In relation to the stored procedures, did you tried to script them and check if all the code on them is compatible with Fabric Data Warehouse ?

Kind Regards,

Dennes