Data Flow Components

Component Key Features

SAS® Data Source Component
SAS® Data SourceSAS® 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 DestinationSAS® 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 SourceData 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 DestinationData 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 DestinationOracle 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 DestinationDB2 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 DestinationInformix 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 SourceEDI 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 PlusScript 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 ParseAddress 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 DestinationODBC 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 PlusLookup 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 SourceSalesforce Source

Salesforce Destination Component
Salesforce DestinationSalesforce Destination

Table Difference Component
Table DifferenceTable Difference

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

Flow Synchronization Component
Flow SynchronizationFlow Synchronization

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

Dynamics CRM Source Component
Dynamics CRM SourceDynamics CRM Source

Dynamics CRM Destination Component
Dynamics CRM DestinationDynamics CRM Destination

Excel Source Plus Component
Excel Source PlusExcel 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 PlusExcel Destination Plus

SharePoint Source Component
SharePoint SourceSharePoint 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 DestinationSharePoint Destination

Dynamics AX Source Component
Dynamics AX SourceDynamics AX Source

Dynamics AX Destination Component
Dynamics AX DestinationDynamics AX Destination

SugarCRM Source Component
SugarCRM SourceSugarCRM Source

SugarCRM Destination Component
SugarCRM DestinationSugarCRM Destination

Dynamics NAV Source Component
Dynamics NAV SourceDynamics NAV Source

Dynamics NAV Destination Component
Dynamics NAV DestinationDynamics NAV Destination

NetSuite Source Component
NetSuite SourceNetSuite Source

NetSuite Destination Component
NetSuite DestinationNetSuite Destination

Dynamics GP Source Component
Dynamics GP SourceDynamics GP Source

Dynamics GP Destination Component
Dynamics GP DestinationDynamics GP Destination

Sage Source Component
Sage SourceSage Source

Sage Destination Component
Sage DestinationSage 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 SourceOpenAir Source

OpenAir Destination Component
OpenAir DestinationOpenAir Destination

Template Component
TemplateTemplate

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

Teradata Destination Component
Teradata DestinationTeradata 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 SourceQuickBooks Source

QuickBooks Destination Component
QuickBooks DestinationQuickBooks Destination

Query Component
QueryQuery

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

Sybase Destination Component
Sybase DestinationSybase 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.

Tableau Destination Component
Tableau DestinationTableau Destination

  • Creation of Tableau Data Extract (TDE) files.
  • Requires deployment of Data Extract API.
  • User interface is based on the standard data flow destination component dialog.