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.