Since the script code in Integrator has full access to the ETL engine, it is possible to create and execute very complex scripts, which work with the files and framework objects outside of Integrator's sandbox.
Read about objects, functions, and methods available in Script flow.
Step 1. Start creating a flow by typing
script into the Select Flow Type box:
Step 3. Add optional named connections that can be referenced and used from the code.
Step 4. Enter other parameters if needed (optional):
- On Exception - by default, any error causes halt of execution. When ignore is selected, the errors will be ignored and execution will continue. Read how to configure the flow to ignore all or specific exceptions.
- Exception Mask - you can specify what errors should be ignored and still halt the execution for all other errors. Enter part or all of the exception string. This field works only when the Ignore On Exception option is selected.