Export (0) Print
Expand All
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)
public sealed class FlatFileColumn : DtsObject, 
	IDTSPersist, IDTSName, IComponent, IDisposable

The FlatFileColumn type exposes the following members.

  NameDescription
Public propertyColumnDelimiterGets or sets the character that is the column delimiter.
Public propertyColumnTypeGets or sets the column type, whether delimited or fixed width.
Public propertyColumnWidthGets or sets the value that indicates how wide a column is when the ColumnType is fixed width.
Public propertyCreationNameReturns 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 propertyDataPrecisionGets or sets the total number of digits in a column that is defined as a numeric data type.
Public propertyDataScaleGets and sets the scale.
Public propertyDataTypeGets or sets the DataType of the value stored in the flat file column.
Public propertyDescriptionGets or sets the column description.
Public propertyIDReturns the unique ID assigned to the column. This property is read-only.
Public propertyMaximumWidthGets or sets the maximum number of bytes to be read from the buffer.
Public propertyNameGets or sets a name for the column.
Public propertySiteInfrastructure. Gets or sets the site of the file column.
Public propertyTextQualifiedGets or sets a Boolean that indicates whether the column is text qualified.
Top
  NameDescription
Public methodDisposeReleases the resources used by the flat file connection.
Public methodEqualsDetermines whether two object instances are equal. (Inherited from DtsObject.)
Public methodGetHashCodeReturns the hash code for this instance. (Inherited from DtsObject.)
Public methodGetType (Inherited from Object.)
Public methodLoadFromXMLThis method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.
Public methodSaveToXMLThis method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.
Public methodToString (Inherited from Object.)
Top
  NameDescription
Public eventDisposedAdds 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)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.