X

Increase Productivity and Decrease Development Time

Task Factory has over 30 components that improve productivity and decrease development time to make your daily tasks much easier.

 
  • Placeholder_Image

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

    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)
  • Placeholder_Image

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

    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.

  • Placeholder_Image

    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.

  • Placeholder_Image

    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.

  • Placeholder_Image

    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.

  • Placeholder_Image

    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.

  • Placeholder_Image

    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.

  • Placeholder_Image

    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.

  • Placeholder_Image

    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.

  • Placeholder_Image

    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.

  • Placeholder_Image

    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.

  • Placeholder_Image

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

  • Placeholder_Image

    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/li>
  • Placeholder_Image

    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/li>
    • Password protected zip files/li>
  • Placeholder_Image

    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.

  • Placeholder_Image

    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.

  • Placeholder_Image

    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.

  • Placeholder_Image

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

    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.

  • Placeholder_Image

    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.

  • Placeholder_Image

    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.

  • Placeholder_Image

    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.

  • Placeholder_Image

    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.

  • Placeholder_Image

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

    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.

  • Placeholder_Image

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

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

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

    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.

  • Placeholder_Image

    FILE GATEWAY SOURCE

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

  • Placeholder_Image

    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.

Task Factory
Call Us At: (904) 413-1911

Contains 65+ tasks, connection managers, sources and Destinations for SSIS. You can compare editions here. Task Factory does not require a license while you're running packages in Visual Studio.

Standard
$1495
Per server
Buy
Pro
$1995
Per server
Buy