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.

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.
• 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.
• Share your exported SSIS scripts with the community.

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.

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

• Reader of EDI format files.
• EDI mapping setup is made in XML configuration file.
• User interface is based on the standard data flow source 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.
• 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.