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.