Sage Source Component is SSIS Data Flow Component for consuming data from Sage SData Service. The configuration parameters 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 parameters below to configure 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
- Where can I find the documentation for the Sage Source?
- How to modify query parameters dynamically at runtime
- How to work with composite records handling in a Sage source component.
- New: Introduced component.
Ready to give it a try?
COZYROC SSIS+ Components Suite is free for testing in your development environment.