The REST Destination Component is an SSIS Data Flow Component for inserting data into a REST resource.
Use the General page of the REST Destination dialog to specify the destination REST resource and options.
Select the COZYROC REST connection manager.
Related Topics: REST Connection Manager
Select the destination resource action. This property has the options listed in the following table.
Action Description Create Create new instances in the destination REST resource. Update Update existing instances in the destination REST resource. Delete Delete existing instances from the destination REST resource. Upsert Update and insert records in the destination REST resource.
Select the destination REST resource.
Specify the number of rows to be sent as a batch. Default is 200.
Specify additional custom metadata.
Specify additional parameters for data insertion.
Use the Mapping page to map input columns to destination REST resource columns.
Select the input columns.
Select the destination REST columns.
Use the Error Output page to select error handling options for the component.
View the name of the destination.
Specify what should happen when an error occurs: ignore the failure, redirect the row, or fail the component.
Related Topics: Handling Errors in Data
View a description of the error.
The DestinationResource, ExtendMetadata and Parameter 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 [REST Destination].[DestinationResource]. This is the property containing the destination resource.
- Scroll down and find the Expressions property. Set up an expression to modify the destination resource dynamically.
The component's Error Output is used for providing both error information and the record identifier information. Check the ErrorCode column:
ErrorCode Description -1 Not an error record. >0 Error record. Check the ErrorDescription column for more details.
You can set up the standard Conditional Split component to filter non-error records.
The composite record input accepts sets of rows, one set for each parent record. Each set of rows must be separated with blank row (all NULLs). The parent record will not finish processing its record, until all composite record children have received blank row to indicate completion. You can use Query transform to prepare child data with the proper blank rows.
Ready to give it a try?
COZYROC SSIS+ Component Suite is free for testing in your development environment.