Using the Destination Component

After Establishing a Connection to the data source, you can add the RSSBus NetSuite Destination Component to the work flow. Follow the steps below to connect to NetSuite and update data.

1. In the SSIS Toolbox, drag the RSSBus NetSuite destination component into the Data Flow Task.
2. Connect the output of a Source Component to the RSSBus NetSuite destination component.
3. Double-click the RSSBus NetSuite Destination Component. The RSSBus NetSuite Destination Editor will display. You can define connection properties in this dialog.
4. In the Connection Managers menu, select an available RSSBus NetSuite Connection Manager, or create a new instance if one is not already available.
5. In the "Use a Table" option, select the table to update.
6. Select the insert, update, upsert, or delete action. See below for more information on each action.
7. On the Mappings tab, configure the mappings from source to destination. By default, outputs from the Source Component will automatically be mapped with the same name as the columns in the table you selected. You can further update these selections.

The Data Flow is now ready to execute and the data from the source will be used to update the destination table. The changes made to the destination table depend on the action as described below.

Insert

The component will take the mapped values and attempt to insert the data as new rows into the table.

Update

The update action is used to update existing rows in a table. The primary key column must be mapped, and it must not be null. The component will attempt to update an existing row based on the primary key provided.

Upsert

The upsert action is used to either insert or update a row in the destination table. The component uses the primary key to decide if a row is to be inserted or updated. If the primary key column is mapped and it is not null, the component will attempt to update an existing row based on the primary key provided. If the primary key is not mapped or if it is null the RSSBus NetSuite Destination Component will attempt to insert the data as a new row.

Delete

The delete action is used to delete existing rows in the destination table. The primary key column must be mapped, and it must not be null. The component will attempt to delete an existing row based on the primary key provided.