Based on users feedback in the latest version of Advanced ETL Processor and Visual Importer ETL we have made it possible to edit Insert/Update/Delete/Count SQL statements manually.
To enable this option
- Click Data target/Writer properties
- Select the Transformation tab
- Tick "Use user-defined SQL" checkbox
- Edit every SQL statement individually.
Note
- To regenerate the SQL statements clear it and open it again.
- Keep the fields order same and in there are any changes with target table structure, regenerate everything again