แชร์ผ่าน


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
public string ColumnDelimiter { get; set; }
public:
property String^ ColumnDelimiter {
    String^ get ();
    void set (String^ value);
}
/** @property */
public String get_ColumnDelimiter ()

/** @property */
public void set_ColumnDelimiter (String value)
public function get ColumnDelimiter () : String

public function set ColumnDelimiter (value : String)

Property Value

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

{|}

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

FlatFileColumn Class
FlatFileColumn Members
Microsoft.SqlServer.Dts.Runtime Namespace