This topic has not yet been rated - Rate this topic

FlatFileColumn Class

SQL Server 2012

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.

Inheritance Hierarchy

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)

Syntax

C++

JScript

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

The FlatFileColumn type exposes the following members.

Properties

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

Top

Methods

	Name	Description
	Dispose	Releases the resources used by the flat file connection.
	Equals	Determines whether two object instances are equal. (Inherited from DtsObject.)
	GetHashCode	Returns the hash code for this instance. (Inherited from DtsObject.)
	GetType	(Inherited from Object.)
	LoadFromXML	This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.
	SaveToXML	This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.
	ToString	(Inherited from Object.)

Top

Events

	Name	Description
	Disposed	Adds an event handler to listen to the Disposed event on the component.

Top

Remarks

This class inherits from the following classes and interfaces:

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Reference

Microsoft.SqlServer.Dts.Runtime Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD