Specify what should happen when a truncation occurs: ignore the failure, redirect the row, or fail the component.

Description

View a description of the error.

FAQ

How to modify source dynamically at runtime

The source worksheet and region are available in the data flow properties list. Follow these steps to set up an expression:

Right-click on the data flow canvas and select the Properties menu.

Scroll down and find the property named like [Excel Source Plus].[Worksheet]. This is the property containing the worksheet.

Scroll down and find the property named like [Excel Source Plus].[Region]. This is the property containing the source region. The property is a string combination containing values for start column, start row, width and height. Each value is separated with a comma (,).

Scroll down and find the Expressions property. Set up an expression to modify the worksheet or region dynamically.

Samples

What's New

1.7 SR-1

New: Component can now read from named ranges pointing to tables.

Fixed: Component failed with error when input cell value was larger than the output column length and the column truncation metadata was set to ignore (Thank you, Dave). For further information check this post.