FlatFileColumn FlatFileColumn FlatFileColumn 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.

public ref class FlatFileColumn sealed : Microsoft::SqlServer::Dts::Runtime::DtsObject, IDisposable, Microsoft::SqlServer::Dts::Runtime::IDTSName, Microsoft::SqlServer::Dts::Runtime::IDTSPersist, System::ComponentModel::IComponent
public sealed class FlatFileColumn : Microsoft.SqlServer.Dts.Runtime.DtsObject, IDisposable, Microsoft.SqlServer.Dts.Runtime.IDTSName, Microsoft.SqlServer.Dts.Runtime.IDTSPersist, System.ComponentModel.IComponent
type FlatFileColumn = class
    inherit DtsObject
    interface IDTSPersist
    interface IDTSName
    interface IComponent
    interface IDisposable
Public NotInheritable Class FlatFileColumn
Inherits DtsObject
Implements IComponent, IDisposable, IDTSName, IDTSPersist


This class inherits from the following classes and interfaces:


ColumnDelimiter ColumnDelimiter ColumnDelimiter ColumnDelimiter

Gets or sets the character that is the column delimiter.

ColumnType ColumnType ColumnType ColumnType

Gets or sets the column type, whether delimited or fixed width.

ColumnWidth ColumnWidth ColumnWidth ColumnWidth

Gets or sets the value that indicates how wide a column is when the ColumnType is fixed width.

CreationName CreationName CreationName 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 DataPrecision DataPrecision DataPrecision

Gets or sets the total number of digits in a column that is defined as a numeric data type.

DataScale DataScale DataScale DataScale

Gets and sets the scale.

DataType DataType DataType DataType

Gets or sets the DataType of the value stored in the flat file column.

Description Description Description Description

Gets or sets the column description.


Returns the unique ID assigned to the column. This property is read-only.

MaximumWidth MaximumWidth MaximumWidth MaximumWidth

Gets or sets the maximum number of bytes to be read from the buffer.

Name Name Name Name

Gets or sets a name for the column.

Site Site Site Site

Gets or sets the site of the file column.

TextQualified TextQualified TextQualified TextQualified

Gets or sets a Boolean that indicates whether the column is text qualified.


Dispose() Dispose() Dispose() Dispose()

Releases the resources used by the flat file connection.

Equals(Object) Equals(Object) Equals(Object) Equals(Object)

Determines whether two object instances are equal.

(Inherited from DtsObject)
GetHashCode() GetHashCode() GetHashCode() GetHashCode()

Returns the hash code for this instance.

(Inherited from DtsObject)
LoadFromXML(XmlNode, IDTSEvents) LoadFromXML(XmlNode, IDTSEvents) LoadFromXML(XmlNode, IDTSEvents) LoadFromXML(XmlNode, IDTSEvents)

This method is not callable by your application code. To load a package saved as .xml, use the LoadPackage(String, IDTSEvents) method.

SaveToXML(XmlDocument, XmlNode, IDTSEvents) SaveToXML(XmlDocument, XmlNode, IDTSEvents) SaveToXML(XmlDocument, XmlNode, IDTSEvents) SaveToXML(XmlDocument, XmlNode, IDTSEvents)

This method is not callable by your application code. To save a package as .xml, use the SaveToXml(String, Package, IDTSEvents) method.


Disposed Disposed Disposed Disposed

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

Applies to