SSIS Components for Microsoft Excel

Build 24.0.8963

AggregateFiles

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

Data Type

bool

Default Value

false

Remarks

When AggregateFiles is set to true, BufferChanges must be set to false.

A single file is used as the metadata document, which defines the expected structure that other files in the aggregation must follow.

You can explicitly set a file to be the metadata document with MetadataDiscoveryURI. If the MetadataDiscoveryURI is not set, the first file in the directory is used as the metadata document.

The component assumes that all files in the directory have the same basic structure.

If the metadata document includes multiple sheets, the component will assume all files in the URI have sheets with the same names.

If some sheets are missing columns but otherwise match the metadata document, the missing columns will return null values.

Files that lack sheets present in the metadata document don't contribute to the aggregation in those sheets' tables.

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