Security at your fingertips
Our File Transfer Task extends the capabilities of the standard SSIS FTP Task by enabling you to transfer data securely using the industry-standard FTPS and SSH protocols, while preserving the familiar user interface.
In addition, we provide an OpenPGP Task for public/private key encryption.
Fast database loads, easy Upsert
Our toolkit includes the Database Destination that supports SQL Server, Oracle, Teradata, PostgreSql, MySQL, DB2, Informix, Sybase and any ODBC-compliant database. You can setup an optimized bulk inserting, updating or upserting in any DB table with a couple of clicks.
The COZYROC Teradata Destination component was a winning solution for Cathay Bank because it delivered technology comparable to what Microsoft provides with SQL Server Enterprise Edition at a fraction of the cost.
Superior MS Excel adapters
The standard SSIS MS Excel adapters are based on the outdated Microsoft Jet technology. They try to guess the data type of Excel columns by inspecting only a small sample of the actual values. Anyone who has used those adapters knows how problematic this approach can be. Our improved Excel components eliminate the guesswork and get the job done in a predictable manner. Unlike the standard adapters, they run fine in both 32bit and 64bit modes and they work with password-protected files.
In addition with our Excel Task you can further tweak your Excel files - edit worksheets, cells and rows, load from or save to stream and more...
SCD transformation, done right
The standard SCD (Slowly Changing Dimension) transformation combo is both slow and confusing. We have created the Table Difference to address all its inconveniences. Our component is much easier to use and is really, really fast.
Table Difference provides more flexibility and options than the corresponding built-ins.
Lookup transformation, simplified
With the standard SSIS Lookup transformation, if you have a situation where there is no match or the input is NULL, you would need two or three additional transformations to handle this. You can only imagine what your data flow would turn into if you needed to process star-schema structures - a giant spider web of complexity.
With Lookup Plus you can dramatically simplify your setup and employ only a single transformation that gets the job done.
Hassle-free email processing
Do you need to download and extract data from email messages? Receive Mail Task provides just the right functionality to get the job done. It supports IMAP, Exchange and POP3 protocols. It can read encrypted messages and attachments, too.
If you need to send emails, we've also got you covered with our Send Mail Task Plus.