FlatFileColumn Class

Article
04/26/2013

Contains information that defines the properties of columns in a flat file source or destination data adapter. The flat file adapter is used for accessing data in flat files. This class cannot be inherited.

Inheritance Hierarchy

System.Object
Microsoft.SqlServer.Dts.Runtime.DtsObject
Microsoft.SqlServer.Dts.Runtime.FlatFileColumn

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

Syntax

'Declaration
Public NotInheritable Class FlatFileColumn _
    Inherits DtsObject _
    Implements IDTSPersist, IDTSName, IComponent, IDisposable
'Usage
Dim instance As FlatFileColumn

public sealed class FlatFileColumn : DtsObject, 
    IDTSPersist, IDTSName, IComponent, IDisposable

public ref class FlatFileColumn sealed : public DtsObject, 
    IDTSPersist, IDTSName, IComponent, IDisposable

[<SealedAttribute>]
type FlatFileColumn =  
    class 
        inherit DtsObject 
        interface IDTSPersist 
        interface IDTSName 
        interface IComponent 
        interface IDisposable 
    end

public final class FlatFileColumn extends DtsObject implements IDTSPersist, IDTSName, IComponent, IDisposable

The FlatFileColumn type exposes the following members.

Properties

	Name	Description
	ColumnDelimiter	Gets or sets the character that is the column delimiter.
	ColumnType	Gets or sets the column type, whether delimited or fixed width.
	ColumnWidth	Gets or sets the value that indicates how wide a column is when the ColumnType is fixed width.
	CreationName	Returns the string that is used by the Integration Services run-time to create an instance of the FlatFileColumn object. This property is read-only.
	DataPrecision	Gets or sets the total number of digits in a column that is defined as a numeric data type.
	DataScale	Gets and sets the scale.
	DataType	Gets or sets the DataType of the value stored in the flat file column.
	Description	Gets or sets the column description.
	ID	Returns the unique ID assigned to the column. This property is read-only.
	MaximumWidth	Gets or sets the maximum number of bytes to be read from the buffer.
	Name	Gets or sets a name for the column.
	Site	Infrastructure. Gets or sets the site of the file column.
	TextQualified	Gets or sets a Boolean that indicates whether the column is text qualified.

Top

Methods

	Name	Description
	Dispose	Releases the resources used by the flat file connection.
	Equals	Determines whether two object instances are equal. (Inherited from DtsObject.)
	GetHashCode	Returns the hash code for this instance. (Inherited from DtsObject.)
	GetType	(Inherited from Object.)
	LoadFromXML	This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.
	SaveToXML	This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.
	ToString	(Inherited from Object.)

Top

Events

	Name	Description
	Disposed	Adds an event handler to listen to the Disposed event on the component.

Top

Remarks

This class inherits from the following classes and interfaces:

Thread Safety

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

Share via