FlatFileColumn Members

  • Article

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.

The following tables list the members exposed by the FlatFileColumn type.

Public Properties

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

Top

Public Methods

(see also Protected Methods )

  Name Description
ms212597.pubmethod(en-US,SQL.90).gif Dispose Releases the resources used by the flat file connection.
ms212597.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from DtsObject )
ms212597.pubmethod(en-US,SQL.90).gif GetHashCode  Returns the hash code for this instance. (inherited from DtsObject)
ms212597.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms212597.pubmethod(en-US,SQL.90).gif LoadFromXML This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.
ms212597.pubmethod(en-US,SQL.90).gifms212597.static(en-US,SQL.90).gif op_Equality  (inherited from DtsObject )
ms212597.pubmethod(en-US,SQL.90).gifms212597.static(en-US,SQL.90).gif op_Inequality  (inherited from DtsObject )
ms212597.pubmethod(en-US,SQL.90).gifms212597.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms212597.pubmethod(en-US,SQL.90).gif SaveToXML This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.
ms212597.pubmethod(en-US,SQL.90).gif ToString  (inherited from Object )

Top

Protected Methods

  Name Description
ms212597.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms212597.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )

Top

Public Events

  Name Description
ms212597.pubevent(en-US,SQL.90).gif Disposed Adds an event handler to listen to the Disposed event on the component.

Top

See Also

Reference

FlatFileColumn Class
Microsoft.SqlServer.Dts.Runtime Namespace