The /n software SSIS Task Library provides robust, enterprise-ready Internet connectivity, secure messaging, compression, and secure file transfer for SQL Server Integration Services (SSIS). The /n software SSIS Tasks for Microsoft SQL Server Integration Services consist of a single task library containing individual tasks for Internet communications. Built from the same core codebase as the /n software Adapters for Microsoft BizTalk Server, the SSIS Tasks provide robust enterprise ready Internet connectivity, secure messaging, and file transfer.

Features

Support for Microsoft SQL Server Integration Services (SSIS) (2005, 2008, 2012, 2014, & 2016).
Fully-managed .NET tasks written in pure C#.
Fully-integrated with the Microsoft Business Intelligence Development Studio.

Internet Communications

FTP SSIS Task - FTP Task with advanced firewall support; SSL Enabled (FTPS).
SFTP SSIS Task - Secure File Transfer through SSH enabled SFTP.
CloudStorage SSIS Task - File storage with S3, Box, DropBox, Google Drive, etc.
OFTP SSIS Task - Odette File Transfer Protocol (OFTP) Task with OFTP2 support.
RSS SSIS Task - RSS client Task for consuming RSS feeds.
SCP SSIS Task - Secure (SSH) Copy Task.
Secure Email SSIS Tasks - Secure Email (SMTP/POP/IMAP) Tasks.
Secure Shell (SSH) SSIS Task - Secure Shell Remote Execution (SExec) Task.
Credit Card SSIS Task - Credit Card authorization and processing Task.
SMPP SSIS Task - Short Message Peer-to-Peer SMS messaging Task.
SNPP SSIS Task - Alphanumeric paging Task.
XMPP SSIS Task - Jabber / XMPP instant messaging Task.
S3 SSIS Task - Integration with Amazon Simple Storage Service (S3).
Telnet Task - Send Terminal Access Commands via Telnet.
TCP Client Task - Basic TCP client communications.

Encryption & Compression:

Zip SSIS Task - Assembler/dissasembler Task with advanced compression features.
Gzip SSIS Task - Gzip assembler / dissasembler.
BZip2 SSIS Task - BZip2 compliant compression/decompression.
AES SSIS Task - 128-bit, 192-bit, and 256-bit AES encryption/decryption.
OpenPGP Task - Sign, verify, encrypt, and decrypt through OpenPGP.
ZCompress SSIS Task - LZC (UNIX Compress) compressor and decompressor.
Tar SSIS Task - Tar archive pipeline. Compatible with the UNIX tar and untar utilities.
Hash SSIS Task - Hash Task can be used to calculate hash values (SHA1, MD5, HMAC, etc.).
EzCrypt SSIS Task - Used to encrypt and decrypt data (AES, DES, Triple DES, Blowfish, etc.).

Only for V.I.P