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

Dymamic SQL

Direct link, no registration required.