Each row in a Secure SQL ServerTM table has a sensitivity column, which contains the sensitivity label for the row. Secure SQL Server uses sensitivity labels to mediate access to data.
When bulk copying into or from a Secure SQL Server table, an application can choose whether or not to include the table’s sensitivity column in the bulk-copy operation.
To include the sensitivity column, an application sets the BLK_SENSITIVITY_LBL property to CS_TRUE. BLK_SENSITIVITY_LBL has a default value of CS_FALSE, which means that by default the sensitivity column is not included.
Users copying into the sensitivity column must have the bcpin_labels_role activated on Secure SQL Server. If a user does not have this role, the bulk-copy operation will fail. See your Secure SQL Server documentation for more information on setting this role.
