|LoggingMode||LoggingMode determines how much information is logged during Package Execution. Set Logging mode to Debugging for maximum log.
|PrefixTimestamp||When you enable this property it will prefix timestamp before Log messages.|
|DoNotCreateOutputs||Enable / Disable Response Output. Checking this option can remove unwanted warnings about unused Columns and many times speedup performance so if output is not needed set this option to True so its removed.|
|TableName||Target table name where you like insert, update or delete records|
|BatchSize||Commit batch size (0=Commit once all source rows are consumed). You can Change Batch Size to commit in smaller chunks too if error handling needed.|
|Action||Action you like to perform (e.g. Upsert, Insert, Update, Delete or Sync)
|EnableInsert||INSERT source rows to target if they don't exist in target table (Only for Sync or Upsert Action)|
|EnableUpdate||UPDATE source rows to target if they exist in target table (Only for Sync or Upsert Action)|
|EnableDelete||DELETE target rows if missing in source (Only for Sync or Upsert Action)|
|CustomTempTableName||User defined Temp table to hold source result before final merge. This table is truncated before each data load. Unlike auto temp table, custom temp table is not dropped after process is finished.|
|PreExecuteCommand||SQL command you like to execute before starting load in target table (e.g. DROP INDEX on target). Along with variable placeholders, you can also use special placeholders [%target_table%], [%temp_table%] and [%target_keys%]|
|PostExecuteCommand||SQL command you like to execute at the end once target table is update (e.g. REBUILD or CREATE INDEX on target table). Along with variable placeholders, you can also use special placeholders [%target_table%], [%temp_table%] and [%target_keys%]|
|DuplicateRemovalMode||Specifies what to do if you encounter duplicate records in source data. You can use first row in the group or keep last row or throw error.