SSIS Components for Microsoft Excel

Build 24.0.9060

Data

This section provides a complete list of the Data properties you can configure in the connection settings for this provider.


PropertyDescription
AllowFormulaWhether or not to treat values starting with an equals (=) sign as formulas during INSERTs and updates.
EmptyValueModeIndicates whether to read the empty values as empty or as null.
NullValuesA comma separated list which will be replaced with nulls if there are found in the CSV file.
IgnoreCalcErrorIndicates whether to ignore errors that occurred during the calculation.
NullValueModeIndicates whether to read empty cells as null or as empty.
HasCrossSheetReferencesIndicates how cross sheet references are handled.
RecalculateIndicates whether to recalculate all formulas when data is read.
ShowEmptyRowsIndicates whether or not the empty rows should be pushed.
TypeDetectionSchemeDetermines how the provider detects the data types of columns.
EnableOleDbCompatibilityIndicates whether to read the data with the same behavior as the Microsoft OleDB driver.
UseFastInsertIndicates whether to use the fastInsert when executing INSERT Statement.
AggregateFilesAllows URI to be set to a local directory instead of a single file. Aggregates the contents of all identically structured files in the directory to one table per sheet.
SkipTopSkips the number of rows specified starting from the top.
IncludeCustomNamesIndicates whether or not the defined names should be pushed.
IncludeSubdirectoriesIncludes the subdirectories of the URI in the aggregation when AggregateFiles is set to true.
MetadataDiscoveryURIIndicates which file is considered the metadata document when the AggregateFiles is set to true.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060