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

If you ever manage to update to SQL Server 2016 you can execute python via a stored procedure. Until then I think you are left with execute process task. I do not know about JS — PacoDePaco
– PacoDePaco, Commented Sep 29, 2017 at 10:33
Thats great! You mean we can execute Python via SQL Stored Procedures! — user1254579
– user1254579, Commented Oct 2, 2017 at 15:06
Yes, but I was wrong about the version - it will be out in SQL Server 2017 soon. Check out more info — PacoDePaco
– PacoDePaco, Commented Oct 3, 2017 at 8:59

cgoll · Accepted Answer · 2017-09-30 17:19:42Z

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#.

answered Sep 30, 2017 at 17:19

cgoll

18111 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1254579 Over a year ago

Thank you .I did use c#/vb.net.Wondering about Pyhon/JS in script componet

immitev · Accepted Answer · 2019-07-09 12:08:10Z

1

With the 1.9 release of COZYROC SSIS+ (a commercial third-party suite of useful SSIS extensions), you can now use JavaScript as a scripting language in SSIS. For more info, see https://www.cozyroc.com/ssis/javascript

Disclaimer: I am working for COZYROC and have been involved in the development of the JS support.

answered Jul 9, 2019 at 12:08

immitev

1112 silver badges9 bronze badges

Comments

Aurangzeb Khan · Accepted Answer · 2024-10-02 04:50:24Z

1

Yes, Python can be used in 'Execute Process task' and we should provide executable path i.e python.exe's path and the path of the file that contain python code.

answered Oct 2, 2024 at 4:50

Aurangzeb Khan

307 bronze badges

1 Comment

Community Over a year ago

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

using of javascript or python in SSIS?

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related