SqlServerPdwLoadingMode Enumeration

The SQL Server PDW Loading Mode enumeration provides options for how data should be loaded into a PDW instance via the SQL Server PDW Destination component.

Enumeration Values

Name	Summary
Append	Specifies that the destination component should append all rows to the existing data in the destination table.
Reload	Specifies that the destination component should truncate the existing data in the destination table before loading rows.
Upsert	Specifies that the destination component should use the specified key columns to determine if rows represent new or existing records. New records should be appended while existing records should be updated.
FastAppend	Specifies that the destination component should append all rows to the existing data in the destination table using fast loading.