Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSDN Library

FlatFileColumn Class

 

Applies To: SQL Server 2016 Preview

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)

System.Object
  Microsoft.SqlServer.Dts.Runtime.DtsObject
    Microsoft.SqlServer.Dts.Runtime.FlatFileColumn

public sealed class FlatFileColumn : DtsObject, IDTSPersist, 
	IDTSName, IComponent, IDisposable

NameDescription
System_CAPS_pubpropertyColumnDelimiter

Gets or sets the character that is the column delimiter.

System_CAPS_pubpropertyColumnType

Gets or sets the column type, whether delimited or fixed width.

System_CAPS_pubpropertyColumnWidth

Gets or sets the value that indicates how wide a column is when the ColumnType is fixed width.

System_CAPS_pubpropertyCreationName

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.

System_CAPS_pubpropertyDataPrecision

Gets or sets the total number of digits in a column that is defined as a numeric data type.

System_CAPS_pubpropertyDataScale

Gets and sets the scale.

System_CAPS_pubpropertyDataType

Gets or sets the DataType of the value stored in the flat file column.

System_CAPS_pubpropertyDescription

Gets or sets the column description.

System_CAPS_pubpropertyID

Returns the unique ID assigned to the column. This property is read-only.

System_CAPS_pubpropertyMaximumWidth

Gets or sets the maximum number of bytes to be read from the buffer.

System_CAPS_pubpropertyName

Gets or sets a name for the column.

System_CAPS_pubpropertySite

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the site of the file column.

System_CAPS_pubpropertyTextQualified

Gets or sets a Boolean that indicates whether the column is text qualified.

NameDescription
System_CAPS_pubmethodDispose()

Releases the resources used by the flat file connection.

System_CAPS_pubmethodEquals(Object)

Determines whether two object instances are equal.(Inherited from DtsObject.)

System_CAPS_pubmethodGetHashCode()

Returns the hash code for this instance.(Inherited from DtsObject.)

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_pubmethodLoadFromXML(XmlNode, IDTSEvents)

This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.

System_CAPS_pubmethodSaveToXML(XmlDocument, XmlNode, IDTSEvents)

This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.

System_CAPS_pubmethodToString()

(Inherited from Object.)

NameDescription
System_CAPS_pubeventDisposed

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

Return to top

Community Additions

Show:
© 2015 Microsoft