SQL Script Action
The SQL Script Action object allows the user to define and identify any SQL scripts to be run (in this case Drop Demo Objects), the connection to be used:
Workflow tab
After execution tab
Specifies which variables will be set once action execution is completed
Always Use sql nocount on for Microsoft SQL Server Stored Procedures and Scripts
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