DTS Programming

RowTerminator Property

The RowTerminator property specifies the row terminator for the Bulk Insert task. The same set of row terminators that apply to the bulk copy program also apply to the Bulk Insert task.

Applies To

BulkInsertTask Object

Syntax

object.RowTerminator [= value]

Part	Description
object	Expression that evaluates to a BulkInsertTask object
value	A row terminator

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetRowTerminator(BSTR *pRetVal);

HRESULT SetRowTerminator(BSTR NewValue);

Remarks

Typical values are CR, CR/LF, LF, ",", ";", tab and "|". The default is a line feed character. It should not be the same as the FieldTerminator property.