Task Factory Feature: Productivity 

SECURE FTP TASK

Brings encrypted security to FTP within SSIS. Many companies transmit files using FTP as a transmission method for highly sensitive files. The Task Factory Secure FTP Task will allow you to transmit files over most common secure channels to your partners safely in an easy to use User Interface.

• Supports SSH, Implicit SFTP and Explicit SFTP
• Supports HTTP, SOCKS4, SOCKS4a and SOCKS5 proxies
• Supports all actions provided by native FTP task

SSIS EMAIL SOURCE ADAPTER

SSIS Email Source Adapter reads email from a mailbox into a data flow with the ability to filter messages based on sender, message to, subject, date received, body and priority.

•  Supports IMAP/POP3
•  Support most email providers (including Gmail)

DATA VALIDATION TRANSFORM

Acts as a gatekeeper for your data. Many companies receive questionable data from various sources, causing a myriad of production problems and inconsistent reporting. Data Validation Transform is an SSIS component that verifies that your data is clean prior to insertion. Rows that are suspicious are flagged for later removal or additional business rules.

Additional features of Data Validation Transform:

• Validates data from a source with the use of regular expressions
• Validates Email, Phone number, SSN and many other patterns
• Regular expression editor included as part of the easy to use UI
• Outputs the results of the data check in each row of the transform output

XML GENERATOR TRANSFORM

XML Generator Transform gives SSIS developers the ability to map XML Schemas (XSD's) to columns from one or more source inputs to generate complex XML documents. This component also allows you to use source data with a matching XSD file to create XML data and organize data into parent and child elements.

DATA FLOW NUGGET

Data Flow Nugget Transform brings the ability to setup a single package with business or data rules that can be reused across several packages. When using the Data Flow Nugget Transform, you have the ability to change the business rules one time instead of changing the rules in every SSIS package that use the same rules.

The Data Flow Nugget Transform component allows you to easily use saved data flow nuggets across multiple SSIS packages to reduce development time.

DOWNLOAD FILE TASK

Download File Task provides a way for you to download files over HTTP from within SSIS without the use of FTP. This component has an easy to use UI to help you download files over HTTP in minutes.

ERROR OUTPUT DESCRIPTION TRANSFORM

Error Output Description Transform is an SSIS component that allows the user to connect error outputs to it from sources and transforms to get detailed information on why the particular row failed. Normally the user is unable to see the data that caused a failure, but with the error output description the user can see not only the exact error, but the row data that caused the error.

ADVANCED EMAIL AND SMS TASK

Advanced Email and SMS Task sends emails from within an SSIS package through SMTP. It allows the use of User/System Variables as placeholders in the email body so variables can be automatically replaced when an email is sent. This component has a built in HTML editor for HTML email and also supports sending SMS messages.

HASH TRANSFORM

Hash Transform is an SSIS component where users can choose from a selection of algorithms to easily create hash values from input columns. Other features include: customizing the order of input, the option to enable padding, adding null replacement character(s), and defining separator character(s). This creates a combined value across multiple columns and makes it easier to find changes in a source or destination set of columns.

ADVANCED EXECUTE PACKAGE TASK

Advanced Execute Package Task provides a way for you to execute a child package from your SSIS package, as well as passing and retrieving variables to and from the child package. It can be used with password protected packages.

The component also allows for variables to be mapped from the parent package to be used in the child package and for the reading of variables from child packages to be used in your SSIS package.

FILE PROPERTIES TASK

This component reads the properties such as File Exists, File Size, File Name, File Content, Creation Time, Is File In Use, Hidden, ReadOnly and then assign them to SSIS package level variables. Many companies receive large data files from outside their organizations and run the risk of loading the file prematurely during transmission causing an SSIS failure.

File Properties Task gives you the power to eliminate this problem by determining if the file is in use or transmitted before loading. File Properties Task additionally saves drive space by identifying old files ready for archive.

TIME ZONE CONVERSION TRANSFORM

Time Zone Conversion Transform is an SSIS component that will convert the value of a target column from one time zone to another and place it into a new column. Time Zone Conversion Transform will allow users to convert dates from one time zone to another using the TZ database from the IANA Organization within just a few minutes.

DATA CLEANSING TRANSFORM

Data Cleansing Transform is an SSIS component that has 16 built-in algorithms that allow you to clean data without any programming or SQL updates. This feature is used to cleanse data from a source by applying cleansing rules to the data.

UNPACK DATA TRANSFORM

Unpack Data Transform allows users to take packed /stuffed XML or delimited text data from a source column and split that data into individual rows and columns in SSIS. You are then able to parse it out into separate user defined columns. The parsed rows of data will be sent out of a separate output with the source input data being sent out of the main output untouched. Unpack Data Transform makes it easy to extract data out of columns in SSIS.

This component will save you from having to write a script component to parse delimited text data or XML data into a separate output. The time savings can reach up to 50 hours depending on the data. Additionally, you can preview what your data will look like.

XML DESTINATION

XML Destination is an SSIS component that allows the user to export source data to an XML File. The name of the column can be customized to output any name needed instead of the column name from the source. The column data can be exported as an attribute, element, element with CDATA or element with XML Data.

With the XML Destination component, Null data can be handled by exporting an empty xml element / attribute, ignoring the attribute / element or replacing the null data with a custom value. Additionally, the order in which the column data is exported can be fully customized. A preview of the file that will be exported can be viewed for correctness in the user interface.

Formatting options:

• Encoding options are UTF-8, UTF-16, UTF-32 or Ascii
• The XML header can be included or left out of the XML file
• Data can be exported on one single line or formatted with a new line after each row, indenting each row and element, adding a new line after each attribute

XML OUTPUT DESTINATION

XML Output Destination is an SSIS component that was created for writing XML files that use large datasets. After pointing to an XSD file, users can establish parent-child relationships between elements, choose between Unicode and UTF8 encoding, and select whether or not the component outputs “Pretty” formatting (indentations and line breaks).

ADVANCED DERIVED COLUMN

Advanced Derived Column extends and replaces the native SSIS Derived Column to allow the user to use our expanded Expression Engine and its 180+ functions to create new columns in your dataflow. The Expression Engine supports multi-line expression, which allows for more complex conditions to be created. The Extended Expression Library allows the user to create new conditions based on expressions not available in SSIS. Unit Tester that comes with the Expression Editor allows the user to test the condition expression before running the package. Expression Reusability allows the user to define an expression and reuse it in other derived conditions.

COMPRESSION TASK (ZIP OR UNZIP)

Compresses or decompresses a file or directory within SSIS. Many companies struggle with transmitting files larger than 1 GB. Compression Task will compress files within SSIS by up to 90%, allowing greater speed and less network space in an easy to use User Interface.

Compression Task supports:

• The use of Zip, Bz2, and GZip compression algorithms
• Creating a self-extracting EXE
• Password protected zip files

ADDRESS PARSE TRANSFORM

Address Parse Transform is an SSIS component that contains data elements including AddressLine1, AddressLine2, City, State, PostalCode, StreetNumber, StreetDirection and much more. This component is used to parse unformatted address data into USPS standardized address data, while granular detailed data available about each address is parsed for use in the data flow.

SURROGATE KEY TRANSFORM

Surrogate Key Transform is an SSIS component that adds an identifier column to a data flow used to uniquely identify a row. This is useful if your data source does not contain an identifier or you simply want to add a row counter to your data flow. It also allows the use of variables to determine seed and increment.

SSIS REPLACE UNWANTED CHARACTERS TRANSFORM

SSIS Replace Unwanted Characters Transform gives the user two options to remove unwanted characters or words from source data. The replaced data can be outputted to the same column in the transform or a new output column.

SSIS PGP ENCRYPTION TASK

SSIS PGP Encryption Task brings easy to use PGP encryption, decryption, file signing and verification to SSIS that is based on OpenPGP technology.

The component also allows for variables to be mapped from the parent package to be used in the child package and for the reading of variables from child packages to be used in your SSIS package.

• File encryption -PGP Task can encrypt a file that can be sent securely, increasing the security available around transporting files through FTP and Email
• File decryption - PGP Task can be used to decrypt a file sent to your system
• File signing - PGP Task can sign a file to allow an end user / system to be able to verify the file being sent was actually created by your system
• File verification - PGP Task can verify the signature of a file sent to your system from a client. This will allow you to verify the file actually was created by the client and not hacked by something else and sent to your system

TIMER TASK

Timer Task is an SSIS component that can be used to add absolute or relative delay (up to days, hours, minutes or seconds) during your execution anywhere in the package.

FILTER ROWS TRANSFORM

Filter Rows Transform allows you to filter rows based on an SSIS expression. This is similar to a conditional split, but now only the rows that match the filter will be sent through to the downflow and the rows that don’t match are filtered out.

• Extended Expression Library allows the user to create filter conditions based on expressions not available in SSIS
• Expression Engine supports multi-line expression which allows for more complex conditions to be created
• Unit Tester that comes with the Expression Editor allows the user to test the condition expression before running the package
• Expression Reusability allows the user to define an expression and reuse it in other derived conditions

ADVANCED AGGREGATOR TRANSFORM

Our Advanced Aggregator Transform takes aggregation in SSIS to the next level. We extended the base functionality of aggregate functions to allow expression based aggregation and added a few more aggregation functions (First, Last) into the equation. So now you can use something like SUM(Quantity, UnitPrice > 20) which will only sum the quantity if the price is greater than 20.

TRIM PLUS TRANSFORM

TrimPlus Transform is an SSIS component that provides a way for users to trim either whitespace or user defined characters from the beginning and end of source columns.

Whitespace trim actions will trim whitespace from column data by:

• Trim all trailing and leading whitespace characters
• Trim all trailing whitespace characters
• Trim all leading whitespace characters

Specified character trim actions allows the user to define the character(s) to be trimmed from the source column data by:

• Trim specified characters from start and end
• Trim specified characters from start
• Trim specified characters from end

TERMINATOR DESTINATION

Terminator Destination is an SSIS component that allows you to quickly add a destination to your package without any configuration. This is useful when developing your SSIS packages and you want to quickly add a destination without having to configure a flat file destination or any other destination that will eventually be detected. This component also easily tests package data flows without having to write data to a destination, as well as giving you the ability to write rows to a file destination for auditing purposes

NULL HANDLER TRANSFORM

Null Handler Transform is an SSIS component that allows the user to replace null or blank values from their source data with a user defined value (e.g. replace null with empty string or vice versa).

With the Null Handler Transform component, there are three actions available to handle null or blank values:

• Convert NULL value to user defined value
• Convert blank value to NULL
• Convert blank value to user defined value

REGEX REPLACE TRANSFORM

RegEx Replace Transform is an SSIS component that allows the user to define a regular expression to either replace (with user defined value) or extract data from a source column. The replaced data can be outputted to the same column in the transform or a new output column.

There are two actions that can be used with this transform:

• The first action is to replace regex matched data with a user defined value. This option allows for the use of capture groups to be part of the replace value. For instance, if the regular expression was for a phone number it would look like something like “(\d{3})[-\)\.\s]?(\d{3})[-\)\.\s]?(\d{4})”. There are three capture groups in that regular expression and you could use $1, $2, $3 to extract the area code, prefix and line number.
• The second action allows the user to define a regular expression to extract data from the source column. There are several options when using this action including extracting capture groups, separating multiple values by a delimiter and providing a “no match” value.

EXPRESSIONS TASK

Expression Task is an SSIS task that allows you to take full advantage of the 180+ functions in our Expression Engine to set variables, call stand-alone functions like CreateFile without any scripting. This component can support replacing placeholders with data created using an expression and can call functions to perform actions like Creating Folders, Sending Emails and Writing files with a single line of code.

FILE GATEWAY TASK

File Gateway Task enables the user to validate that a text file contains the expected information in the expected format prior to using it. This is beneficial for those who work with a lot of text files, particularly if those files come in from outside sources.

FILE GATEWAY SOURCE

The File Gateway Source enables you to validate text files by separating valid and invalid rows into success and error output.

EXCEL COMPONENTS

EXCEL SOURCE

The Excel Source allows users to connect to an existing Excel file and extract its data. Using OpenXML, the Excel Source sends the rows into a data flow.

EXCEL DESTINATION

The Excel Destination allows users to connect to a new or existing Excel file and write data to it using OpenXML.

*See the Excel Connection Manager page to learn more about setting up this component's connection manager.