How to write powershell script in talend DI

[rohit1804]

I want to write powershell script in talend DI. Can you please guide me how to write it ?

[gjeremy1617088143]

Hi you have to use tSystem component to run the console of your computer, and by this way you can run powershell and a script in command line with it,

you can also create the poweshell script into a pst file and then execute it via tSystem component.

https://help.talend.com/r/en-US/7.2/system/tsystem-standard-properties

[Anonymous · Accepted solution]

Hi @rohit bannagare​ 

No a dedicated component for writing powershell script, I think you can write the powershell script on a tJavaRow or tJava component, store the whole script content as string variable for used later, write the script string as a *.ps1 file using tFileOutputDelimited if needed, call a powershell script file using tSystem component.

Regards

Shong