Calling SQL Scripts

You can execute a script against any connection that supports SQL. For example, you can run a script that drops certain indexes before running a job, and then run another script that adds them back when the job is complete.

Note: The Insight Adapter for Microsoft Dynamics GP is the only adapter that supports scripts. They are not supported for other adapters. For more information, see the online help for your adapter.

Before you specify a script on the SQL Scripts tab, TIBCO recommends using a standard database query utility to write, test, and debug that script.

To call a script before or after a DTS run

  1. Select View > Connections. The Connection Manager appears.
  2. Select the connection you want to change and click Edit. The Connection Settings dialog box appears.
  3. Click the DTS Connection Settings tab.
  4. Browse to the script that you want to execute before or after the DTS runs.
  5. Click OK.

See also

Connection Settings Dialog Box

Command Delimiters

Comment Syntax