Attribute | Description | Required |
---|
connstring | Connection string used to access database. This should be an OLEDB connection string. | True |
source | File where the SQL statements are defined. You cannot specify both a source and an inline set of statements. | False |
delimiter | String that separates statements from one another. | True |
batch | If true, the statements will be executed as a single batch. If false, they will be executed one by one. Default is true. | False |
expandprops | If true, then any NAnt-style properties on the SQL will be expanded before execution. Default is true. | False |
delimstyle | Delimiters can be of two kinds: Normal delimiters are always specified inline, so they permit having two different statements in the same line. Line delimiters, however, need to be in a line by their own. Default is Normal. | True if using delimiter |
print | If set to true, results from the statements will be output to the build log. | False |
output | If set, the results from the statements will be output to the specified file. | False |
transaction | If set to true, all statements will be executed within a single transaction. Default value is true. | False |
failonerror | Determines whether task failure stops the build or is just reported. Default is "true." | False |
verbose | Task reports detailed build log messages. Default is "false." | False |
if | If true then the task will be executed; otherwise skipped. Default is "true." | False |
unless | Opposite of if. If false then the task will be executed; otherwise skipped. Default is "false." | False |