Skip to Content
DocsOperationsRunSourceScript

RunSourceScript

RunSourceScript allows you to execute any update or DLL statement (or series of them - a script) in the language supported by the source. For example, you can use RunSourceScript to execute a series of SQL update/insert/delete and/or DLL statement in a relational database source.

There are two ways to pass a script to the operation:

  • By creating a script in the Scripts section of the application navigation tree. In this case the source selection is a part of the script specification. You can select any script from the RunSourceScript operation specification.

  • By writing a script in the built-in editor that is part of the RunSourceScript specification.

In both of this cases you can specify parameter of the script in the following JSON format: {<parameter1Name>: “<value1>”, <parameter2Name>: “<value1>” ... }.

For MSSQLSource insert a line “go” after each SQL statement in the script. If you fail to do so the statement will not be executed without any error.

Last updated on
RunScenarioSendEmail