TMSLoader.Options Property

Used to specify the behaviour of a TMSLoader object.

Use the Options property to specify the behaviour of a TMSLoader object.

Descriptions of all options are in the table below.

Option Name	Description
CheckConstraints	Used to specify if the table constraints are checked during loading.
FireTrigger	Allows table triggers to be fired with TMSLoader on SQL Server during insertion, deactivated by default.
KilobytesPerBatch	Used to specify the size of data in kilobytes to load in a single batch.
LockTable	Used to specify if the table-level lock is performed while loading is in progress.
RowsPerBatch	Used to specify the number of rows to load in a single batch.