Script Task DLLs on SQL Server PaaS
We have observed that default .Net DLLs are available in Managed instance however if we can make available all .Net reference / DLL like Azure functions . Specially for those tenant who are using SQL Managed instance for ADF V2 / SSIS as a services.
As per my experience, many people are using .Net script task in SSIS to achieve complex logic which we can not achieve through SSIS adapter and in this case we need additional DLLs. We can still install DDLs if we are using AZURE servers but if we are following as services approach (which we are following) than we can’t install it.