How to migrate .dtsx package which executes python script to SSIS Linux using dtexec?

Question

I am migrating SSIS ETL from Windows to Linux and using dtexec. In Windows, the executables can be added as C:....\python.exe. I would like to know how the same can be migrated to Linux as python3 will be present in /usr/bin/python3.

I have tried adding paths like C:\usr\bin\python3 as SSIS on Linux maps the Windows-style path C:\test to the Linux-style path /test. But it didn't work.

The error is caused by this command:

/opt/ssis/bin/dtexec /Pack xxx.dtsx /Proj xxx.ispac /decrypt test

Error: 2022-01-13 20:10:42.83
Code: 0xC002F304
Source: DDL Execute Process Task
Description: An error occurred with the following error message: "The specified executable is not a valid application for this OS platform.".

Answer 1

Hi @Shanthini D ,

To Run an SSIS package on Linux, you may take a reference sql-server-linux-migrate-ssis.

There is also Limitations and known issues for SSIS on Linux.

Like Execute Process task, it only supports in-process mode.

I'm not familiar with python script.

Also see here about details: sql-server-linux-ssis-known-issues

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.