Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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.


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.

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.

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

Public eventDisposedAdds an event handler to listen to the Disposed event on the component.

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.

Community Additions

© 2015 Microsoft