Data Flow Components

SAS® Data Source Component
SAS® Data Source

• Premium component licensed separately from SSIS+ library.
• Installation and licensing of SAS® Analytics not required.
• Streaming data read, allowing processing of unlimited amounts of data.
• User interface is based on the standard data flow source component dialog.

SAS® Data Destination Component
SAS® Data Destination

• Premium component licensed separately from SSIS+ library.
• Installation and licensing of SAS® Analytics not required.
• User interface is based on the standard data flow destination component dialog.

Data Flow Source Component
Data Flow Source

• Based on Package Connection Manager.
• Very fast, non-blocking, in-memory data read from another data flow.
• Scalable alternative of the recommended Microsoft solution with raw data file source.
• User interface is based on the standard data flow source component dialog.
• Check for yourself the performance by downloading this SSIS package.

Data Flow Destination Component
Data Flow Destination

• Exposes data from a data flow for in-memory read in another data flow.
• Scalable alternative of the recommended Microsoft solution with raw data file destination.
• User interface is based on the standard data flow destination component dialog.

Oracle Destination Component
Oracle Destination

• Bulk-load destination Oracle table component.
• 10-30x faster loading speed compared to OLE DB.
• Support for Oracle 9i release 2, 10g release 1, 10g release 2, and 11g release 1 databases.
• User interface is based on the standard data flow destination component dialog.

DB2 Destination Component
DB2 Destination

• Bulk-load destination DB2 table component.
• 20x faster loading speed compared to OLE DB.
• IBM UniData® and UniVerse® data servers are not supported.
• User interface is based on the standard data flow destination component dialog.

Informix Destination Component
Informix Destination

• Bulk-load destination Informix table component.
• 6-8x faster loading speed compared to OLE DB.
• Support for IBM Informix® Dynamic Server, Version 11.10 or later.
• User interface is based on the standard data flow destination component dialog.

EDI Source Component
EDI Source

• Very fast reader of EDI format files. The component can reportedly process millions of segments in less than 30 minutes.
• EDI mapping setup is made in XML configuration file.
• User interface is based on the standard data flow source component dialog.

Script Component Plus
Script Component Plus

• Extension of Microsoft SSIS Script Component, meaning you already have the skills to use it.
• Greater reusability and easier maintenance of SSIS scripts.
• Customizable script user interface and setup.
• SSIS Script export, import or linking to.
• Keep your script code separate from your package and have easier time tracking changes in your source control system.
• Requires SQL Server 2005 SP2.
• Reusable scripts and samples from the public repository.

Address Parse Component
Address Parse

• US Postal Address parsing, correction and standardization.
• Parsed address parts: leading, street, number, suite, city, state, zip code.
• Optional feature to check address in USPS reference database with more than 120 million addresses.
• Intuitive user interface with fine-grained error control.

ODBC Destination Component
ODBC Destination

• Based on ODBC Connection Manager.
• Support regular and bulk ODBC insertion.
• Support 64bit ODBC drivers.
• Support redirection of incorrect rows to error output.
• User interface is based on the standard data flow destination component dialog.

Lookup Plus Component
Lookup Plus

• Support OLEDB, ADO, ADO.NET or package variable as a source.
• Support Distributed Cache (1.5 SR-1).
• Support multiple lookup definitions in one place.
• Support definition for handling NULL and No Match situations.
• Intuitive user interface.

Salesforce Source Component
Salesforce Source

• Based on Salesforce Connection Manager.
• Support both object and SOQL statement as a source.
• User interface is based on the standard data flow source component dialog.

Salesforce Destination Component
Salesforce Destination

• Based on Salesforce Connection Manager.
• Store data into Salesforce service object.
• Support regular and bulk-load (1.6).
• User interface is based on the standard data flow destination component dialog.

Table Difference Component
Table Difference

• Memory efficient detection of differences between two tables.
• Faster alternative of the standard SCD component.
• Intuitive user interface.

Flow Synchronization Component
Flow Synchronization

• Makes two or more data flows run with same speed.
• Intuitive user interface.

Dynamics CRM Source Component
Dynamics CRM Source

• Based on Dynamics CRM Connection Manager.
• Support both entity and FetchXML statement as a source.
• User interface is based on the standard data flow source component dialog.

Dynamics CRM Destination Component
Dynamics CRM Destination

• Based on Dynamics CRM Connection Manager.
• Store data into Microsoft Dynamics CRM service entity.
• Support CRM 2011 bulk-load (1.6 SR-1).
• User interface is based on the standard data flow destination component dialog.

Excel Source Plus Component
Excel Source Plus

• Based on Excel Connection Manager.
• Support 64 bit execution.
• Support reading of raw, formatted and formula cell value.
• Intuitive user interface with fine-grained error control.

Excel Destination Plus Component
Excel Destination Plus

• Based on Excel Connection Manager.
• Support 64 bit execution.
• Intuitive user interface with fine-grained error control.

SharePoint Source Component
SharePoint Source

• Based on SharePoint Connection Manager.
• Support batch reading from Microsoft SharePoint list.
• Support specifying of Microsoft SharePoint list view.
• Support CAML queries and includes designer for simplifying query creation.
• User interface is based on the standard data flow source component dialog.

SharePoint Destination Component
SharePoint Destination

• Based on SharePoint Connection Manager.
• Store data into Microsoft SharePoint list.
• User interface is based on the standard data flow destination component dialog.

Dynamics AX Source Component
Dynamics AX Source

• Based on Dynamics AX Connection Manager.
• Support both table and statement as a source.
• User interface is based on the standard data flow source component dialog.

Dynamics AX Destination Component
Dynamics AX Destination

• Based on Dynamics AX Connection Manager.
• Store data into Microsoft Dynamics AX server table.
• User interface is based on the standard data flow destination component dialog.

SugarCRM Source Component
SugarCRM Source

• Based on SugarCRM Connection Manager.
• User interface is based on the standard data flow source component dialog.

SugarCRM Destination Component
SugarCRM Destination

• Based on SugarCRM Connection Manager.
• Store data into SugarCRM module.
• User interface is based on the standard data flow destination component dialog.

Dynamics NAV Source Component
Dynamics NAV Source

• Based on Dynamics NAV Connection Manager.
• User interface is based on the standard data flow source component dialog.

Dynamics NAV Destination Component
Dynamics NAV Destination

• Based on Dynamics NAV Connection Manager.
• Store data into Dynamics NAV page.
• User interface is based on the standard data flow destination component dialog.

NetSuite Source Component
NetSuite Source

• Based on NetSuite Connection Manager.
• Support read of composite NetSuite record field.
• User interface is based on the standard data flow source component dialog.

NetSuite Destination Component
NetSuite Destination

• Based on NetSuite Connection Manager.
• Store data into NetSuite record.
• Support write of composite NetSuite record field.
• User interface is based on the standard data flow destination component dialog.

Dynamics GP Source Component
Dynamics GP Source

• Based on Dynamics GP Connection Manager.
• Support read of composite Dynamics GP object property.
• User interface is based on the standard data flow source component dialog.

Dynamics GP Destination Component
Dynamics GP Destination

• Based on Dynamics GP Connection Manager.
• Store data into Dynamics GP object.
• Support write of composite DynamicsGP object property.
• User interface is based on the standard data flow destination component dialog.

Sage Source Component
Sage Source

• Based on Sage Connection Manager.
• Support read of composite Sage entity property.
• User interface is based on the standard data flow source component dialog.

Sage Destination Component
Sage Destination

• Based on Sage Connection Manager.
• Store data into Sage entity.
• Support write of composite Sage entity property.
• User interface is based on the standard data flow destination component dialog.

OpenAir Source Component
OpenAir Source

• Based on OpenAir Connection Manager.
• User interface is based on the standard data flow source component dialog.

OpenAir Destination Component
OpenAir Destination

• Based on OpenAir Connection Manager.
• Store data into OpenAir type.
• User interface is based on the standard data flow destination component dialog.

Template Component
Template

• Generation on arbitrary text columns based on Apache Velocity template.
• Support multiple template column definitions.
• Intuitive user interface.

Teradata Destination Component
Teradata Destination

• Bulk-load destination Teradata table component.
• 80x faster loading speed compared to ODBC.
• User interface is based on the standard data flow destination component dialog.

QuickBooks Source Component
QuickBooks Source

• Based on QuickBooks Connection Manager.
• Support read of composite QuickBooks object field.
• User interface is based on the standard data flow source component dialog.

QuickBooks Destination Component
QuickBooks Destination

• Based on QuickBooks Connection Manager.
• Store data into QuickBooks object.
• Support write of composite QuickBooks object field.
• User interface is based on the standard data flow destination component dialog.

Query Component
Query

• Support OLEDB, ADO, ADO.NET connection types.
• Support query statement setup from current data flow row.
• Intuitive user interface.

Sybase Destination Component
Sybase Destination

• Bulk-load destination Sybase table component.
• 20x faster loading speed compared to OLE DB.
• Requires Adaptive Server Enterprise version 15.7.
• User interface is based on the standard data flow destination component dialog.