SQL Script Action

The SQL Script Action runs SQL scripts

Workflow tab

1. Write Variables option forces package action to save variables values into the log file before the execution.
2. It is usually used for debugging and not recommended for production environment.
3. It can be globally disabled using options dialogue

After execution tab

Specifies which variables will be set once action execution is completed