Data Flow Task Plus
Data Flow Task Plus

• Extension of Microsoft SSIS Data Flow Task.
• Greater reusability and easier maintenance of data flows.
• Customizable user interface for data flows setup.
• SSIS data flows export, import or linking to.
• Keep your data flows implementation separate from your package and have easier time tracking changes in your source control system.
• Make Data Flow Task Plus interoperate with other data flows by using Data Flow Source and Data Flow Destination components.
• Support for dynamic data flows.

Database Partitions Task
Database Partitions

• Saves you time by handling the intricacies of the partitioning and letting you concentrate on your workflow instead.
• Create, insert and remove database partitions in Microsoft SQL Server 2005 and up.
• Combine smaller partitions into a larger one, for easy backup later.
• Support for ADO.NET, OLEDB, ADO connection managers.
• Easy to use interface.

Script Task Plus
Script Task Plus

• Extension of Microsoft SSIS Script Task, 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.

Zip Task
Zip Task

• Compression and decompression of Zip, GZip, BZip2, Unix, Tar archives.
• Automatically switches to Zip64 format, if it is required.
• Support for input and output data streaming, without a need for temporary storage.
• Support extraction from multi-volume Zip archive (1.3 SR-3).
• Streamlined user interface.

SFTP Task
SFTP Task

• Based on SSH Connection Manager.
• Based on FTPS Connection Manager (1.3).
• Secure FTP communications and management.
• Support for send, receive and delete files, create and remove directory, rename file commands.
• Support for input and output data streaming, without a need for temporary storage.
• The user interface covers most of the functionality of the standard Microsoft SSIS FTP task and it is very similar.

SSH Execute Task
SSH Execute Task

• Based on SSH Connection Manager.
• Secure execution of shell commands on a remote SSH server.
• Streamlined user interface.

OpenPGP Task
OpenPGP Task

• Public key cryptography based on OpenPGP standard.
• Support for file encryption, decryption, signature creation and verification.
• Support for input and output data streaming, without a need for temporary storage.
• Streamlined user interface.

Amazon S3 Task
Amazon S3 Task

• Based on Amazon S3 Connection Manager.
• Support file sending, receiving, removing and retrieval of remote files list.
• Support for input and output data streaming, without a need for temporary storage.
• Streamlined user interface.

Jabber Task
Jabber Task

• Based on Jabber Connection Manager.
• Support bidirectional communication with Jabber clients - sending and receiving of messages.
• Support text or HTML message sending.
• Streamlined user interface.

Stream Task
Stream Task

• Support creation of stream, opening of file stream, reading from stream and writing to stream.
• Support in-memory transfer stream, allowing simultaneous writing of data in one process and reading of the same data in another process.
• Streamlined user interface.

Template Task
Template Task

• Generation of arbitrary text documents like CSV, HTML, XML, EDI and many more.
• Streaming document generation, meaning low memory requirements and unlimited document generation.
• Template engine based on Apache Velocity.
• User interface includes syntax-highlighting editor and template-testing tools.

SCP Task
SCP Task

• Based on SSH Connection Manager.
• Secure copying of files with remote SSH server.
• Streamlined user interface.

Send Mail Task Plus
Send Mail Task Plus

• Based on SMTP Connection Manager.
• Support sending of secure S/MIME emails.
• Support From, To, CC, BCC, Body, Body HTML, Priority, Attachment parameters.
• Streamlined user interface.

Receive Mail Task
Receive Mail Task

• Based on IMAP Connection Manager.
• Based on POP3 Connection Manager.
• Support receiving and opening of secure S/MIME emails.
• Support filtering with criteria of received emails.
• Streamlined user interface.

Excel Task
Excel Task

• Based on Excel Connection Manager.
• Support 64 bit execution.
• Support creating, deleting, clearing and renaming of worksheets.
• Support find and replace of cells in Excel worksheets.
• Streamlined user interface.

Parallel Loop Task
Parallel Loop Task

• Based on Package Connection Manager.
• Improves loop execution time dramatically by executing multiple Foreach loop iterations concurrently.
• Support both dynamic variables and dynamic connection managers.
• Streamlined user interface.

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 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.
• 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.
• 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.

SSH Connection Manager
SSH Connection Manager

• Secure connections with SSH-enabled server.
• Authenticate with password or private key file.
• Support for Tunnel (HTTP), SOCKS4, SOCKS5 proxy.
• Support SSH2.
• Support File Transfer Protocol version 0, 1, 2, 3.
• Support for secure tunnels (port forwarding) (1.5).
• Streamlined user interface.

Package Connection Manager
Package Connection Manager

• Get access to the current or different package at runtime.
• Support for all current types of package storage: SQL, File, SSIS Package Store.
• Support for package variables initialization before execution.
• Easy to use interface.

Amazon S3 Connection Manager
Amazon S3 Connection

• Connections with Amazon S3 Service.
• Optional support for proxy.
• Streamlined user interface.

Jabber Connection Manager
Jabber Connection

• Connections with Jabber servers.
• Support socket, HTTP polling and HTTP binding connection types.
• Support for SOCKS4, SOCKS5, HTTP proxy.
• Streamlined user interface.

FTPS Connection Manager
FTPS Connection Manager

• Secure connections with FTP over SSL server.
• Secure connections with FTP over TLS server.
• Connections with straight FTP server.
• Support for Explicit and Implicit FTPS.
• Support for OTP S/Key password protection.
• Support for SOCKS4, SOCKS5, HTTP, FTP proxy.
• Streamlined user interface.

Salesforce Connection Manager
Salesforce Connection Manager

• Connections with Salesforce service.
• Streamlined user interface.

Dynamics CRM Connection Manager
Dynamics CRM Connection Manager

• Connections with Microsoft Dynamics CRM service.
• Support Premise, Live, Hosted deployments.
• Support Dynamics CRM 3.0 systems.
• Streamlined user interface.

SMTP Connection Manager
SMTP Connection Manager

• Connections with SMTP mail server.
• Support secure connections.
• Streamlined user interface.

POP3 Connection Manager
POP3 Connection Manager

• Connections with POP3 mail server.
• Support secure connections.
• Streamlined user interface.

IMAP Connection Manager
IMAP Connection Manager

• Connections with IMAP mail server.
• Support secure connections.
• Streamlined user interface.

Excel Connection Manager
Excel Connection Manager

• Connections to Microsoft Excel workbook files.
• Support 64 bit execution.
• Support Microsoft Excel 97-2010 and Pocket Excel workbook files.
• Support password-protected workbooks.
• Streamlined user interface.

SharePoint Connection Manager
SharePoint Connection Manager

• Connections with Microsoft SharePoint service.
• Streamlined user interface.