using of javascript or python in SSIS?

Question

I am planning to use of javascript or python in SQL SERVER INTEGRATION SERVICES (SSIS ETL).Does it has to be utilised using the execute process task.Is there any other way to replace the existing script task with python and or javascript {The current script task/components only support Vb/C# :( ) .Please share your thoughts

Answer 1

You can only use VB/C# in the script task.

https://learn.microsoft.com/en-us/sql/integration-services/control-flow/script-task

Script Language

Select the scripting language for the task, either Microsoft Visual Basic or Microsoft Visual C#.