DTS Programming

FieldTerminator Property

The FieldTerminator property specifies the field or column terminator for files that support char and widechar data types.

Applies To

BulkInsertTask Object

Syntax

object.FieldTerminator [= value]

Part	Description
object	Expression that evaluates to a BulkInsertTask object
value	Field terminator

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetFieldTerminator(BSTR *pRetVal);

HRESULT SetFieldTerminator(BSTR NewValue);

Remarks

Typical values are ",", ";", tab and "|". These values are also valid in the bulk copy program. The default is tab. It must not be the same as the RowTerminator property.