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.