SQL Scripts

Once data is loaded into the database user may want to perform various tasks like transformations, validations or calculations. The user may perform any SQL command allowed by the target database. SQL commands must be separated by a separator. SQL Scripts Screen is designed to provide such functionality for the end user.

  • To create a new SQL Script select SQL scripts group from objects tree and click New
  • Dialog box will appear
  • Fill in Description edit box with the name of SQL Script you are about to create
  • Fill in a comment if required
  • Click OK to finish the creation of SQL Script

To edit script double click on any previously created SQL Scripts.

SQL Scripts Tool Bar

  1. SQL Script Properties
  2. Load the SQL script from the disk
  3. Save the SQL script to the disk
  4. Save the SQL Script to the repository
  5. Print the SQL script
  6. Preview
  7. Cut
  8. Copy
  9. Paste
  10. Undo
  11. Completion Proposal
  12. Search
  13. Repeat Search
  14. Find Previous
  15. Replace
  16. Execute SQL Script
  17. Stop execution when an error happens
  18. SQL script separator
  19. Connection
  20. Show connections only for current project
  21. Show/hide log
  22. View Execution Log (When executed within the package or by agent/scheduler)
  23. Schedule for execution
  24. Manage Versions
  25. Add Version
  26. Revert to previous version
  27. Make SQL Script read-only
  28. Browse data
Always Use set sql nocount on for Microsoft SQL Server Stored Procedures and Scripts 
SQL Script supports both package and global variables

Automatic Version Control

Every time the user presses save button package is automatically added to the version control

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL Forum

,
  • aetle/sql_scripts.txt
  • Last modified: 14/04/2019 14:40
  • by admin