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
- SQL Script Properties
- Load the SQL script from the disk
- Save the SQL script to the disk
- Save the SQL Script to the repository
- Print the SQL script
- Preview
- Cut
- Copy
- Paste
- Undo
- Completion Proposal
- Search
- Repeat Search
- Find Previous
- Replace
- Execute SQL Script
- Stop execution when an error happens
- SQL script separator
- Connection
- Show connections only for current project
- Show/hide log
- View Execution Log (When executed within the package or by agent/scheduler)
- Schedule for execution
- Manage Versions
- Add Version
- Revert to previous version
- Make SQL Script read-only
- 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