Property | S/T | Description |
---|---|---|
CommitFrequency | T | Controls how often data is committed to the database. Default is zero, meaning that data is committed at the end of the transformation, allowing rollback on error. This is the slowest setting. When doing large transformations, this is not practical as it may produce too many transaction log entries. Setting the CommitFrequency to some nonzero value tells the connector to do a database commit after inserting or updating the specified number of records. This keeps the transaction log from getting too large but limits the restartability of the transformation. |
ConstraintDDL | T | Pass-through mechanism that allows you to specify any additional data definition language (DDL) statements that need to be executed when a new table is created. DDL is used to define keys, indexes, constraints, and integrity rules for SQL databases. There is no default. |
Encoding | T | Type of encoding used with your source and target files. Default is OEM. |
IdentityInsert | T | By default, identity fields are not inserted into the database. To enable insertion of identity fields, change to true. |
SystemTables | T | If set to true, allows you to see all tables created by the DBA in the database. The system table names appear in the table list. Default is false. Note: This property is applicable only if the user is logged onto the database as the database administrator. Only the DBA has access to system tables. |
Tablock | T | Either true (default) or false. |
Views | T | If set to true (default) this property allows you to see views. The view names appear in the table list along with the tables. (This property is available on all SQL connectors, but Mass Inserts can only write to tables, not views. So setting this to true has no effect in this instance.) |