SQLDTS.comSQLIS.comSQLIS Wiki
Products

A range of third-party components are appearing for SQL Server Integration Services, and we are compiling a list of them for you below. Don't forget that the following free components are all available directly from this site:

  • Checksum Transformation
  • Data Generator Source
  • File Watcher Task
  • Regular Expression Transformation
  • Row Count Plus Transformation
  • Row Number Transformation
  • Trash Destination Adapter
  • For more SSIS related products and components try those listed below.



    Oracle .Net Destination Connector
    Oracle .Net Destination Connector for SSIS. Free destination adapter.

    Oracle Bulk Load
    Oracle Bulk Load Connector for SSIS. Available as trail or for purchase.

    SalesForce Connector
    SalesForce Source Connector for SSIS. Available as trail or for purchase.

    DataDefractor - SSIS Data Flow Source
    DataDefractor™ is a custom Microsoft SQL Server 2005 Integration Services (SSIS) data flow source component, which extracts fact data and dimensional metadata from various unstructured and semi-structured data sources and feeds it into the SSIS pipeline.

    BI Documenter
    End-to-end SQL Server Documentation, with support for relational databases, Analysis Services and Integration Services packages in the same set of documentation.

    Xtract IS - Plug and play SAP connectivity with SQL Server Integration Services
    Xtract IS provides a selection of three components for SAP data extraction through SQL Server 2005 Integration Services. They include a SAP Table source, a SAP Query source, a SAP BW Cube source and a connection manager to support these components.

    /n software inc: IP*Works! SSIS Tasks
    Based on their existing IP*Works! components, /n software have produced a large range of tasks for internet communications, and secure shell (SSH) enabled client communications. The tasks cover quite range, "...transferring files, sending and receiving emails, consuming webservices, sending instant messages.... all of the major communications technologies available in IP*Works! and IP*Works! S/Shell are currently available."

    AMB Dataminers: eCartography Microsoft SSIS Data Migration Pack
    eCartography – Predictive Data Management from AMB Dataminers. "This application will support the creation and maintenance of eCartography datamaps. In addition the application will predict the actions (Domain, Relationship etc …) required for individual columns and guide the user thru the analysis and correction. With the associated Microsoft SQL Server Integrated Services eCartography (SSIS) components, this product will eliminate the need for external data profiling and data cleansing software provided such vendors as First Logic, Trillium, Evoke etc ... "

    Persistent Systems SSIS Oracle Bulk Load Connector
    "High speed Oracle Destination connector with SSIS that gives a 100 times performance improvement over the existing OLEDB connector….The SSIS Oracle Bulk Load Connector has been built as a component to be available inside Business Development Studio environment. As a data flow Destination Component, it can be used in Data Flow tasks of SSIS to bulk load data into Oracle Server."

    ETI HPC for Teradata Source for Microsoft SSIS
    ETI High Performance Connector for Microsoft SSIS-Teradata, a streaming source component to provided fast transfer of data from NCR Teradata to Microsoft SQL Server Integration Services. (PDF)

    Ivolva: ExtraSort
    ExtraSort Component for Integration Services improves on the built-in sorting routine and enables smooth scaling to large data sets.

    Ordinal: Nsort for SQL Server Integration Services
    Nsort for SQL Server Integration Services, can be used alongside standard SSIS components during the design and execution of an SSIS project. It is faster and more efficient than the stock sort, with reduced CPU and no memory limitations, as well offering multiple input and output streams.

    SPSS: SPSS Statistical Services for Microsoft SQL Server 2005
    SPSS Statistical Services integrates SPSS functionality at the Data Flow level within Integration Services. Database professionals can utilize SPSS functionality directly within the Integration Services environment.