DtTextProvider

Description

The DtTextProvider class implements an object that imports data from text files.

Comments

Object of the class can be used for direct data import from text files, and is also used for setting of the Import from Text ETL task object.

Properties Inherited from IDtTextProvider

	Property name	Brief description
	AllowMuchColumnDelimiter	The AllowMuchColumnDelimiter property determines whether to skip delimiters running in succession.
	DataFromClipboard	The DataFromClipboard property determines whether to use clipboard as the data provider for import.
	DelimitedColumnDelimiter	The DelimitedColumnDelimiter property determines the symbol, used as a field delimiter in the text file.
	DelimitedColumnDelimiters	The DelimitedColumnDelimiters property determines the rows array, used as a field delimiter in the text file.
	DelimitedTextQualifier	The DelimitedTextQualifier property determines the character used as a text delimiter.
	Encoding	The Encoding property determines symbols encoding, used during data import.
	File	The File property determines the path and the name of the text file, from which the data is imported.
	FormatType	The FormatType property determines file structure format, according to which data is imported.
	GetFieldsFromFile	The GetFieldsFromFile property returns the number of fields, obtained according to installed settings, from the source file.
	HeaderRow	The HeaderRow property determines the number of row that contains fields headers.
	RangeFirstRow	The RangeFirstRow property determines the number of the row starting from which the data is imported.
	RangeHasHeader	The RangeHasHeader property determines whether column headers are located in the first file row.
	RowDelimiter	The RowDelimiter property determines the symbol, used as a row delimiter.
	TextCodePage	The TextCodePage property determines the encoding used on data import from file.

Properties Inherited from IDtProvider

	Property name	Brief description
	AutoFillFieldsMode	The AutoFillFieldsMode property determines the field type detection mode of the data provider.
	CalcFieldsErrors	The CalcFieldsErrors property returns a collection of errors appeared on calculated fields calculation.
	Eof	The Eof property returns True if the cursor in the data source is on the last record.
	FetchErrors	The FetchErrors property returns errors occurred on data import.
	FilterIf	The FilterIf property returns condition of loading of records from data provider.
	StringDataFormat	The StringDataFormat property returns settings used on data identification.
	TypeGuessRows	The TypeGuessRows property determines number of rows by means of which the data type of each field will be determined.

Properties Inherited from IDtObject

	Property name	Brief description
	Active	The Active property returns data source or data consumer state.
	Fields	The Fields property returns data provider/data consumer fields description.
	GetType	The GetType property returns data provider/data consumer type.
	Metabase	The Metabase property determines the repository, in which data is imported or exported.

Methods Inherited from IDtProvider

	Method name	Brief description
	Fetch	The Fetch method reads data of the current entry from the data provider.
	FetchRows	The FetchRows method reads data of the specified number of entries from the data provider and returns the number of actually read entries.
	ReadingRowsCount	The ReadingRowsCount method returns the number of records read from the data source with taking into account loading condition.
	ReadingRowsTotalCount	The ReadingRowsTotalCount method returns the number of records read from the data source without taking into account loading condition.

Methods Inherited from IDtObject

	Method name	Brief description
	ClearFields	The ClearFields method clears fields list of the data provider or data consumer.
	Close	The Close method closes data provider or data consumer.
	FieldsFromFile	The FieldsFromFile method reads fields list from the source file.
	Load	The Load method loads data source or data consumer parameters from XML.
	Open	The Open method opens data provider or data consumer.
	Save	The Save method saves data source or data consumer parameters in XML format.

See also:

Dt Assembly Classes