• Article

FlatFileColumn Class

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
Public property ColumnDelimiter Gets or sets the character that is the column delimiter.
Public property ColumnType Gets or sets the column type, whether delimited or fixed width.
Public property ColumnWidth Gets or sets the value that indicates how wide a column is when the ColumnType is fixed width.
Public property 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.
Public property DataPrecision Gets or sets the total number of digits in a column that is defined as a numeric data type.
Public property DataScale Gets and sets the scale.
Public property DataType Gets or sets the DataType of the value stored in the flat file column.
Public property Description Gets or sets the column description.
Public property ID Returns the unique ID assigned to the column. This property is read-only.
Public property MaximumWidth Gets or sets the maximum number of bytes to be read from the buffer.
Public property Name Gets or sets a name for the column.
Public property Site Infrastructure.
Public property TextQualified Gets or sets a Boolean that indicates whether the column is text qualified.

Top

Methods

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

Top

Events

  Name Description
Public event 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.