Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,990 questions
Lift&Shift: SSIS to Azure Data Factory
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 57.00000000000001%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
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?
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee2022-03-22T21:59:49.86+00:00 Hello @pepekali,
Thanks for the patience , unfortunately since we are not sure what the 3rd party dll is , we are unable to test this .If you have a support plan you may file a support ticket, else could you please send an email to azcommunity@microsoft.com with the below details, so that we can create a one-time-free support ticket for you to work closely on this matter.
Subscription ID:
Subject : Attn Himanshu
Please let me know once you have done the same.
Thanks
Himanshu -
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee
2022-03-24T19:03:08.447+00:00 Hello @pepekali,
We haven’t received any email from you as requested in the last response and was just checking back to see if you have a resolution . In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, please respond back with the more details as requested and we will try to help .
Thanks
Himanshu
Sign in to comment
Sign in to answer