Sage Destination Component is SSIS Data Flow Component for loading data into Sage SData entity. The configuration parameters are provided in the standard data flow destination component dialog. A separate input 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
Select destination entity action. This property has the options listed in the following table.
Action Description Create Create new record in the destination entity. Update Update existing record in the destination entity. You have to specify entity key for the update to work. Delete Delete existing record from the destination entity.After action change, you have to use Refresh command in the 'Column Mappings' tab to reload destination page metadata.
Specify the number of rows to be sent as a batch.
Specify the destination Sage SData entity where the data is loaded.
Specify how to handle rows with errors.
- Where can I find the documentation for the Sage Destination?
- How to work with composite records handling in a Sage destination component.
- How to find which records contain errors in Sage destination component.
- New: Introduced component.
Ready to give it a try?
COZYROC SSIS+ Components Suite is free for testing in your development environment.