AccessKey: AKIAIOSFODNN7EXAMPLE SecretKey: wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEYClick here to read more how to get your AccessKey and Secret Key
|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.|
|SwitchToRowByRowOnBatchFail||When this option is true then each batch is processed in bulk mode in first attempt and when it fails that particular batch is processed in row by row mode to detect bad record. By default when error occurs all records from that batch is rejected but when this option is true you can process all good records and only reject records causing error.|
|TableName||Table name from where you want to read data|
|BatchSize||Indicates how many records are process in a single request. Setting this value to 0 will extract all records in single request.|
|AccessMode||Indicates Access Mode of data (e.g. Table or Sql Query)
|SqlCommand||Specifies SQL query to access data. This setting is ignored when access mode is set to Table.|
|Operation||Specifies operation for destination data load (e.g. Insert, Reload etc). Default operation is Insert (data always appended to target).
|RequestDelay||Delay time in milliseconds. This is time to wait before sending next request. This is useful to throttle requests/second. Sometimes server allows x requests/seconds and if you send more requests it may throw error. This setting will help you to slow down.|
|MetaDataScanMode||Metadata scan mode controls how data type and length is determined. By default few records scanned to determine datatype/length. Changing ScanMode affects length/datatype accuracy.|
|MetaDataCustomLength||Length for all string column. This option is only valid for MetaDataScanMode=Custom|