I have been using the Azure Data Factory as the ETL tool but I would like to downgrade/migrate to the on-prem SSIS due to business decision. Is there a way to go about this except re-writing the pipelines? Maybe a lift and shift solution?
All the solutions I see is migrating from SSIS to ADF only.
unfortunately there is no direct mapping/conversion tool between SSIS and ADF .As ADF is still a developing tool, not all features of SSIS are present within ADF and vice versa. You would have to manually reciprocate your add pipeline logic in ssis either via normal dataflow/control activities wherever possible or use script task to handle the non available ones.
Also in ADF, are you using dataflows or normal activities? Also, can you just privide the image of your overall ADF pipeline flow ? Source and sink etc as it may help us help you better