Sage Source Component is SSIS Data Flow Component for consuming data from Sage SData Service. The configuration options are provided in the standard data flow source component dialog. A separate output is setup for the main entity and each related composite entity.
Use the options below to setup the component.
Select an existing Sage connection manager.
Related Topics: Sage Connection Manager
Specify the number of rows to be retrieved as a batch.
Select Sage entity.
Specify SData query parameters. Multiple parameters are separated with newline. For example to retrieve account entity records where names start with the letter M and include related Addresses information specify the following parameters:
where=AccountName like 'M%' include=Addresses
Composite entity data
The composite entity output contains not only properties from the composite entity, but also the parent entities. The output will be populated with sets of records, one set for each parent record. Each set of records is separated with blank row (all NULLs).
How to modify query parameters dynamically at runtime?
The source entity and query parameters are available in the data flow properties list. Follow these steps to setup expression:
- Right-click on data flow canvas and select Properties menu.
- Scroll-down and find property named like [Sage].[QueryParameters]. This is the property containing the query parameters.
- Scroll-down and find Expressions property. Setup expression to modify the criteria dynamically.