SSIS Components for Anaplan

Build 26.0.9655

ExportMetadata

Retrieves detailed metadata for a specific export definition, including column names, data types, and row count estimates.

Table-Specific Information

Select

The component uses the Anaplan API to process WHERE clause conditions that are built with the following columns and operators:

  • ExportId supports the '=' comparison operator.
  • ModelId supports the '=' comparison operator.
  • WorkspaceId supports the '=' comparison operator.

For example, the following queries are processed server-side:

SELECT * FROM [ExportMetadata] WHERE [ExportId] = '123' AND [ModelId] = '456' AND [WorkspaceId] = '789'

The component processes other filters client-side within the component.

Columns

Name Type References Description
ExportId [KEY] String

Exports.Id

The unique identifier of the export definition.
ModelId [KEY] String

Models.Id

The ID of the model the export belongs to.
WorkspaceId String

Workspaces.Id

The ID of the workspace the model belongs to.
ColumnCount Int The number of columns in the export.
RowCount Long Estimated number of rows in the export (may differ slightly from actual export).
Format String The MIME type format of the export.
Encoding String The character encoding of the export.
Delimiter String The delimiter character used for quoting fields.
Separator String The separator character used between fields.
HeaderNames String Array of column header names in the export.
DataTypes String Array of data types for each column.
ListNames String Array of list names associated with ENTITY type columns.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655