FlatFileColumn.ColumnDelimiter Property
Gets or sets the character that is the column delimiter.
Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
Syntax
'Declaration
Public Property ColumnDelimiter As String
Get
Set
'Usage
Dim instance As FlatFileColumn
Dim value As String
value = instance.ColumnDelimiter
instance.ColumnDelimiter = value
public string ColumnDelimiter { get; set; }
public:
property String^ ColumnDelimiter {
String^ get ();
void set (String^ value);
}
member ColumnDelimiter : string with get, set
function get ColumnDelimiter () : String
function set ColumnDelimiter (value : String)
Property Value
Type: System.String
A String that contains the character that is the column delimiter in the file.
Remarks
The following table shows the valid values.
Description |
Characters |
|---|---|
Carriage return line feed |
{CR}{LF} |
Carriage return |
{CR} |
Line feed |
{LF} |
Semi-colon |
{;} |
Colon |
{:} |
Comma |
{,} |
Tab |
{t} |
Vertical Bar |
{|} |