Skip to main content

SqlServerPdwLoadingMode Enumeration

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​

NameSummary
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.