You are here:

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.

SQL scripts must conform to the syntax rules for their corresponding database utility, such as Query Analyzer for Microsoft SQL Server. You can create scripts using ODBC SQL standard syntax. If a script does not follow syntax rules, that script fails.
Each utility has rules for entering comments and commands in a script. Syntax differences for comments and command delimiters do not affect script execution.
SQL Scripts must be located in a folder relative to the DTS file.

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

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