SQL Scripts

About

SQL scripts are typically used to perform database operations that are beyond the capabilities of standard data transformation steps. They can be written and executed to automate tasks, run custom queries, or interact with databases in various ways.

Properties Dialogue

Parameters Tab

Comments Tab

User Fields Tab

SQL Script

SQL Script Toolbar

1. SQL Script Properties
   Access and configure script properties.

2. Notes
   Add or view notes related to the SQL script.

3. Load SQL Script from Disk
   Load an existing SQL script from your local storage.

4. Save SQL Script to Disk
   Save the current SQL script to your local storage.

5. Save SQL Script to Repository
   Save the SQL script into the repository for version control.

6. Print SQL Script
   Print the SQL script for documentation or sharing.

7. Preview
   Preview the script before execution.

8. Cut
   Cut the selected part of the script to clipboard.

9. Copy
   Copy the selected part of the script to clipboard.

10. Paste
    Paste the clipboard content into the script editor.

11. Undo
    Undo the last action made in the script.

12. Completion Proposal
    Suggests completions for the SQL script based on context.

13. Search
    Search for specific content within the script.

14. Repeat Search
    Repeat the last search query.

15. Find Previous
    Find the previous occurrence of the search query.

16. Replace
    Replace text within the script.

17. Execute SQL Script
    Execute the SQL script on the selected database.

18. Stop Execution on Error
    Stop the execution immediately if an error occurs.

19. SQL Script Separator
    Define separators for multiple statements in the script.

20. Connection Selection Box
    Select the database connection to run the script against.

21. Show Connections Only for Current Project
    Filter and show connections specific to the current project.

22. Show/Hide Log
    Toggle visibility of the execution log.

23. Schedule for Execution
    Schedule the SQL script for execution at a specified time.

24. View Execution Log
    View the execution log when the script is run by the package or agent/scheduler.

25. Manage Versions
    Manage and track versions of the SQL script.

26. Add Version
    Add a new version of the SQL script to version control.

27. Revert to Previous Version
    Restore the SQL script to a previous version.

28. Make SQL Script Read-Only
    Set the script to read-only to prevent modifications.

29. Browse Data
    Browse the data related to the SQL script execution.

Version Control

Each time the Save button is pressed, the SQL script is automatically added to the version control system.

• Learn more about version Control