How to run SSIS packages using Execute package activity in ADF Pipeline, When the package contains a script file that uses .exe files

Question

Hi Team,
we are migrating our on-prem databases to Azure Sql managed Instance and as a part of migration we wanted to run our ssis packages in ADF using Execute SSIS package activity.

But in our SSIS packages we have some script task which are using winscp.exe files to place resultset flat files in a sftp location.
Till now we didn't find any solution to execute ssis packages in adf with minimum changes.

Do we have any solution for this?

Answer 1

Hi @Indra Lakshmi Rupa Madhuri Boddeda

Greetings & Welcome to Microsoft Q&A forum! Thanks for posting your query!

Did you got a chance to look into these documentations? It might provide some insights that could help resolve your query.

Documentation links:

https://learn.microsoft.com/en-us/training/modules/execute-existing-ssis-packages-azure-data-factory/1-introduction

Run an SSIS package with the Execute SSIS Package activity in Azure portal

I hope this information helps.

Thank you.