QuickBooks Destination

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

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

All Downloads ----- Questions?

Overview

The QuickBooks Destination Component is an SSIS Data Flow Component for loading data into QuickBooks objects. The configuration parameters are provided in the standard data flow component dialog. When working with composite data, a separate input must be set up for the main object and each related composite object.

Demonstration

Demonstration VideoDemonstration Video

Setup

Use the parameters below to set up the component.

Parameters

QUICKBOOKS

Select an existing QuickBooks connection manager.

Related Topics: QuickBooks Connection Manager

Action

Select the destination object action. This parameter has the options listed in the following table.

Action Description
Create Create new records in the destination object.
Update Update existing records in the destination object. The ListID and EditSequence columns must be used to specify the records to be updated.
Delete Delete existing records from the destination object. The ListID column must be used to specify the records to be deleted.
Void Void existing records from the destination object. The ListID column must be used to specify the records to be voided.
BatchSize

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

DestinationObject

Specify the QuickBooks object on which the action is to be performed.

ErrorRowDisposition (QuickBooks Destination Input)

Specify how to handle rows with errors.

Id (QuickBooks Destination Error Output)

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

EditSequence (QuickBooks Destination Error Output)

Contains the QuickBooks EditSequence field of the added or updated record.

Composite object data

The composite object input accepts sets of records, one set for each parent record. Each set of records must be separated with a blank row (all NULLs). The parent object will not finish processing its record until all composite object children have received a blank row to indicate completion of the composite data. See the demonstration video for an example of creating records containing composite data.

How to find which records contain an error

The component's Error Output is used for providing both error information and the record identifier of the processed records. 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.