Sdílet prostřednictvím


DWCopyCommandSettings interface

DW Copy Command settings.

Properties

additionalOptions

Additional options directly passed to SQL DW in Copy Command. Type: key value pairs (value should be string type) (or Expression with resultType object). Example: "additionalOptions": { "MAXERRORS": "1000", "DATEFORMAT": "'ymd'" }

defaultValues

Specifies the default values for each target column in SQL DW. The default values in the property overwrite the DEFAULT constraint set in the DB, and identity column cannot have a default value. Type: array of objects (or Expression with resultType array of objects).

Property Details

additionalOptions

Additional options directly passed to SQL DW in Copy Command. Type: key value pairs (value should be string type) (or Expression with resultType object). Example: "additionalOptions": { "MAXERRORS": "1000", "DATEFORMAT": "'ymd'" }

additionalOptions?: {[propertyName: string]: string}

Property Value

{[propertyName: string]: string}

defaultValues

Specifies the default values for each target column in SQL DW. The default values in the property overwrite the DEFAULT constraint set in the DB, and identity column cannot have a default value. Type: array of objects (or Expression with resultType array of objects).

defaultValues?: DWCopyCommandDefaultValue[]

Property Value