FlatFileColumn Class

Definition

Namespace:

Microsoft.SqlServer.Dts.Runtime

Assembly:

Microsoft.SqlServer.ManagedDTS.dll

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

Inheritance

Object

DtsObject

FlatFileColumn

Implements

IDTSName IDTSPersist IComponent IDisposable

Remarks

This class inherits from the following classes and interfaces:

• DtsObject

• IDTSPersist

• IDTSName

• IComponent

• IDisposable

Properties

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	Gets or sets the site of the file column.
TextQualified	Gets or sets a Boolean that indicates whether the column is text qualified.

Methods

Dispose()	Releases the resources used by the flat file connection.
Equals(Object)	Determines whether two object instances are equal. (Inherited from DtsObject)
GetHashCode()	Returns the hash code for this instance. (Inherited from DtsObject)
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)	This method is not callable by your application code. To save a package as .xml, use the SaveToXml(String, Package, IDTSEvents) method.

Events

Disposed

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