NetSuite Destination

SQL Server 2005, 2008, 2008R2, 2012, 2014

SQL Server 2005, 2008, 2008R2, 2012, 2014

All Downloads ----- Questions?

Overview

NetSuite Destination Component is SSIS Data Flow Component for loading data into NetSuite record. The configuration options are provided in the standard data flow destination component dialog. A separate input is setup for the main record and each related composite record.


Setup

Use the options below to setup the component.

Options

NETSUITE

Select an existing NetSuite connection manager.

Related Topics: NetSuite Connection Manager

Action

Select destination record action. This property has the options listed in the following table.

Action Description
Create Create new instance in the destination NetSuite record.
Update Update existing instance in the destination NetSuite record. You have to specify internalId for the update to work.
Delete Delete existing instance from the destination NetSuite record.
Upsert Update and insert record in the destination NetSuite record. You have to specify externalId for action to work.

Note: After action change, you have to use Refresh command in the 'Column Mappings' tab to reload destination page metadata.

DestinationRecord

Specify the destination NetSuite record where the data is loaded.

BatchSize

Specify the number of rows to be sent as a batch.

ErrorRowDisposition (NetSuite Destination Input)

Specify how to handle rows with errors.

Id (NetSuite Destination Error Output)

Contains the unique identifier of the added, updated or deleted record.

Composite record data

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.

How to find which records contain an error?

The component's Error Output is used for providing both error information and the processed record identifier. 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 a standard Conditional Split component to filter non-error records.