SQLOLEDB bulk-copy rowsets are write-only, but the rowset exposes interfaces that allow the consumer to determine the structure of an SQL Server table. The following interfaces are exposed on a bulk copy-enabled SQLOLEDB rowset:
The provider-specific properties SSPROP_FASTLOADOPTIONS, SSPROP_FASTLOADKEEPNULLS, and SSPROP_FASTLOADKEEPIDENTITY control behaviors of an SQLOLEDB bulk-copy rowset. The properties are specified in the rgProperties member of an rgPropertySets IOpenRowset parameter member.
| Property ID | Description |
| SSPROP_ FASTLOADKEEPIDENTITY |
Column: No R/W: Read/write Type: VT_BOOL Default: VARIANT_FALSE Description: Maintains identity values supplied by the consumer. VARIANT_FALSE Values for an identity column in the SQL Server table are generated by SQL Server. Any value bound for the column is ignored by SQLOLEDB. VARIANT_TRUE The consumer binds an accessor providing a value for an SQL Server identity column. The identity property is not available on columns accepting NULL, so the consumer provides a unique value on each IrowsetFastLoad::Insert call. |
| SSPROP_FASTLOADKEEPNULLS | Column: No R/W: Read/write Type: VT_BOOL Default: VARIANT_FALSE Description: Maintains NULL for columns with a DEFAULT constraint. SSPROP_FASTLOADKEEPNULLS affects only SQL Server columns that accept NULL and have a DEFAULT constraint applied. VARIANT_FALSE SQL Server inserts the default value for the column when the SQLOLEDB consumer inserts a row containing NULL for the column. VARIANT_TRUE SQL Server inserts NULL for the column value when the SQLOLEDB consumer inserts a row containing NULL for the column. |
| SSPROP_FASTLOADOPTIONS | Column: No R/W: Read/write Type: VT_BSTR Default: none Description: Reserved for future use. |