Export (0) Print
Expand All

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
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2015 Microsoft