PrimaryKeys
The column, or comma-separated list of columns, to use as the primary key for a table. The value in each row of the primary key column must be unique (the combination of values must be unique if you specify multiple columns). You must set this parameter so that the connector can determine whether rows are new, have been modified, or have been deleted.
The columns must be selected by the query specified by the SQL
parameter (or AddedAndUpdatedStatement
and DeletedStatement
when UseIncrementalStatements=true
).
NOTE: The value of this parameter is case-sensitive.
NOTE: You do not need to set the PrimaryKeys
parameter for sub-tables.
Type: | String |
Default: | |
Required: | Yes |
Configuration Section: | TaskName or FetchTasks |
Example: |
or
|
See Also: | SQL |