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

Indra Lakshmi Rupa Madhuri Boddeda 0 Reputation points
2024-10-09T08:48:16.89+00:00

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?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,803 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
537 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Chandra Boorla 2,525 Reputation points Microsoft Vendor
    2024-10-09T19:13:06.69+00:00

    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://video2.skills-academy.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.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.