Using the Destination Component
After Establishing a Connection to the data source, add the CData LinkedIn destination component to the workflow to load data into LinkedIn.
Writing to LinkedIn in a Data Flow
Follow the steps below to connect to LinkedIn and update data.
- In the SSIS Toolbox, drag the CData LinkedIn destination component into the Data Flow Task.
- Connect the output of a source component to the CData LinkedIn destination component.
- Double-click the CData LinkedIn destination component. The CData LinkedIn Destination Editor dialog is displayed.
- In the Connection Managers menu, select an available CData LinkedIn connection manager, or create a new instance if one is not already available.
- In the "Use a Table" option, select the table to update.
- Select the data manipulation action. See below for more information on each action.
- On the Mappings tab, configure the mappings from source to destination. By default, outputs from the source component are automatically mapped with the same name as the columns in the table you selected. You can further update these selections.
NOTE: Read-only columns are not visible among the destination columns since they cannot be written to.
Command Execution
When you execute the data flow, the component executes one of the following operations to update the destination table.
Insert
The component takes the mapped values and attempt to insert the data as new rows into the table. By setting the OutputKey property to True in the destination component's properties, you can retrieve the results of the insertion in the error output of the component with the 'Redirect row' error behavior.