Hello Experts - I would like to understand the best optimal and suitable option or solution here between the 2 :
Scenario : I have an SSIS package with lot of transformations and dynamic data loads on premise and the requirement is to migrate this on premise SSIS ETL to Azure , specifically ADF .
Is it better to create altogether a new ETL on ADF with pipelines?
Lift and shift this SSIS and execute in Azure SSIS runtime?
Which one is better and any other suggestions ?
Thanks,
Deepak.