Home Library Learn Downloads Support Community
Sign in | United States - English | |
This topic has not yet been rated - Rate this topic

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.

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)
C#
C++
F#
JScript
VB
Copy 
public sealed class FlatFileColumn : DtsObject, 
	IDTSPersist, IDTSName, IComponent, IDisposable

The FlatFileColumn type exposes the following members.

  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. Gets or sets the site of the file column.
Public property TextQualified Gets or sets a Boolean that indicates whether the column is text qualified.
Top
  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
  Name Description
Public event Disposed Adds an event handler to listen to the Disposed event on the component.
Top

This class inherits from the following classes and interfaces:

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Did you find this helpful?
(1500 characters remaining)