Lift&Shift: SSIS to Azure Data Factory

Pankaj Mandania 61 Reputation points

Hi, we have SSIS packages built in SQL Sever version 2012. We had a used third party component to carry out some tasks in SSIS. Now we want to Lift and Shift there packages (over 3000 plus) to Managed Instance in Azure but when we carried out the assessment using DMA , we got some error messages. Basically the error message was saying the DLL was old and not compatible

We dont want to recreate the whole DW and the workaround is to use the latest DLL which will enable us to run the packages in azure via data factory.

My question is there a way that we can deploy the DLL somehow in azure so that we can continue using the SSIS packages?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,751 questions
{count} votes