When using the traditional MultiLoad protocol, the target table cannot have any of the following characteristics:
- Join, hash, or secondary indexes
- No primary index
- Foreign key references
- Referential integrity
- Triggers
- Cannot be a normalized table
- Cannot be a column partitioned table
- Cannot be a temporal table
- Cannot be in a replication group
The Extended MultiLoad Protocol can be used to load target tables that cannot be loaded using the traditional MultiLoad protocol. The exceptions are:
- Cannot be a column partitioned table
- Cannot be a temporal table
- Cannot be in a replication group
- Cannot have an identity column defined as a primary index