Download and install python from https://www.python.org/downloads
Note: that for conda distributions to work properly, you need to add Format(’%s;%0:s\Library\bin;’, [Version.InstallPath] to your Windows path if it is not there already.
Here is a very basic example where we are converting a string into the upper case using python
The script checks a number of the day and shows an appropriate message
The execution result is determined by Result.Value, Result.Value=1 means success and Result.Value=0 means failure
“etltools” package provides a way of communication between python and our software.\ It is only available when python is run from our software.
etltools.GetVariable('<VariableName>')\ etltools.SetVariable('<VariableName>','Important Value')\ etltools.WriteToLog('Important Message')\ etltools.ExecuteObject(ObjectID)
Use ExecuteObject to execute object from the script inside the package
It returns the result of the package/transformation execution that was called.