CODEWITHSUNDEEP
javascriptpythonssisetlssis-2012
user1254579
user1254579

Reputation: 4009

using of javascript or python in SSIS?

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

Upvotes: 3

Views: 1222

Answers (3)

Aurangzeb Khan
Aurangzeb Khan

Reputation: 11

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.

Upvotes: 0

immitev
immitev

Reputation: 101

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.

Upvotes: 1

cgoll
cgoll

Reputation: 181

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

Upvotes: 1

Related Questions