Hi Team,
I am doing a migration from SSIS to Azure Data Factory via Lift and Shift operation. Existing SSIS packages using DLLs and Script Task to achieve certain functionality such as reading data from Dynamics 365, PDF, Microsoft documents and writing data to excel etc.
I would like to reuse the existing SSIS package as it is. SSIS Packages will be deployed in Azure SQL Managed Instance with the required Azure compatibility changes.
Is there any way to deploy/Import the DLL in Azure SQL MI ?
Jayraj ChhayaPosted Jun 18, 2024, 11:38 AM
Azure SQL Managed Instance does not support importing or using custom DLLs directly within the database. However, you can achieve similar functionality by creating Azure Functions or Azure SQL CLR (Common Language Runtime) stored procedures. Azure Functions allow you to run code in a serverless environment, while Azure SQL CLR stored procedures enable you to run .NET code within the database.
To migrate your existing functionality, consider refactoring the DLL logic into Azure Functions or Azure SQL CLR stored procedures. This approach ensures compatibility with Azure SQL Managed Instance while maintaining the required functionalities.