ODBC or text sources are accessed using VBScript objects. You can use these objects only in the Before Query and After Query scripts. For more information, refer to VBScript objects. The most common tasks performed with the query object are:
Use the following procedure to attach a script to an ODBC or text source.
A list of the scripts for the source appears.
The type of script you choose depends on when the script should run.
Script event |
Description |
The script runs once before any data is retrieved from the source. |
|
The script runs once after Integration Manager has processed all source records for the source. |
The Script Editor window appears, where you can write the script.
To remove a script, select the script in the list and choose Remove Script. |