NetSuite Source

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

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

All Downloads ----- Join VIP ----- Questions?

Overview

NetSuite Source Component is SSIS Data Flow Component for consuming data from NetSuite Service. The configuration options are provided in the standard data flow source component dialog. A separate output 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

BatchSize

Specify the number of rows to be retrieved as a batch. Default is 0. If set to 0, the page size defined in NetSuite search preferences will be used.

InputType

Specify input type. This property has the options listed in the following table.

Value Description
Record Input type is NetSuite record or composite object. Selecting this value displays the dynamic options Record, RecordId, RecordVariable.
SearchXML Input type is search statement. Selecting this value display the dynamic options SearchXML.

Note: After input change, you have to use Refresh command in the 'Column Mappings' tab to reload source object metadata.

Record

Select NetSuite record or composite object.

SearchXML

Specify NetSuite search record statement. The statement should be the same XML format used in NetSuite search method. For example to retrieve all account records containing the keyword "Drawing" in account's name, use the following statement:

<AccountSearchBasic>
  <name operator="contains">
    <searchValue>Drawing</searchValue>
  </name>
</AccountSearchBasic>

Composite record data

The composite record output contains not only fields from the composite record, but also the parent records. The output will be populated with sets of rows, one set for each parent record. Each set of rows is separated with blank row (all NULLs).

How to modify source statement dynamically at runtime?

The source record or statement are available in the data flow properties list. Follow these steps to setup expression:

  • Right-click on data flow canvas and select Properties menu.
  • Scroll-down and find property named like [NetSuite Source].[SearchXML]. This is the property containing the record statement.
  • Scroll-down and find Expressions property. Setup expression to modify the record statement dynamically.