X
Task Factory

SSIS Components That Save You Time and Money

Task Factory offers essential, high-performance components and tasks for SSIS that eliminate the need for programming. With over 60 components, Task Factory can increase productivity, improve performance and increase your ROI.

 

What's Included in Task Factory

Placeholder_Image USPS Address Verification

The USPS Address Verification component can accept address information and validate it against the USPS database.

Included in:

Community

Standard

Pro

Placeholder_Image Dimension Merge SCD Transform

Dimension Merge SCD is an SSIS component designed to handle most dimension loading scenarios with few clicks in-memory. Experience loading a dimension up to 700 times faster in SSIS!

Included in:

Community

Standard

Pro

Placeholder_Image Fact Table Destination

Fact Table Destination can greatly reduce development time for SSIS packages with multiple dimension lookups.

Included in:

Community

Standard

Pro

Placeholder_Image REST Source and Destination

Allows you to import and export data from any web service that uses a Rest API.

Included in:

Community

Standard

Pro

Placeholder_Image Upsert Destination

Upsert Destination is an SSIS component that helps synchronize two systems no matter the source or destination.

Included in:

Community

Standard

Pro

Placeholder_Image Secure FTP Task

Bring encrypted security to FTP within SSIS. Secure FTP Task will allow you to transmit files over most common secure channels to your partners safely.

Included in:

Community

Standard

Pro

Placeholder_Image File Gateway Task

The File Gateway Task enables you to validate that a text file contains the expected information in the expected format prior to using it.

Included in:

Community

Standard

Pro

Placeholder_Image Secure FTP Task

Bring encrypted security to FTP within SSIS. Secure FTP Task will allow you to transmit files over most common secure channels to your partners safely.

Included in:

Community

Standard

Pro

Placeholder_Image Azure ML Batch Execution Task

A control flow component that controls the batch execution of an Azure ML Web Service. Can be used with the Azure ML Storage Destination and Azure ML Storage Source to insert data before a batch execution and then retrieve the results of a batch execution.

Included in:

Community

Standard

Pro

Placeholder_Image SharePoint Documents Task

SharePoint Documents Task is an SSIS task that gives users the ability to upload or download documents to or from a document library in a SharePoint server.

Included in:

Community

Standard

Pro

Placeholder_Image Advanced Email and SMS Task

Advanced Email and SMS Task sends emails from within an SSIS package through SMTP.

Included in:

Community

Standard

Pro

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.

Included in:

Community

Standard

Pro

Placeholder_Image Advanced Execute Process Task

Advanced Execute Process Task is an SSIS task that provides a way for you to execute commands as if you were using the command line utility in windows.

Included in:

Community

Standard

Pro

Placeholder_Image Compression Task

Compression Task will compress files within SSIS by up to 90%, allowing greater speed and less network space.

Included in:

Community

Standard

Pro

Placeholder_Image Excel Power Refresh Task

Excel Power Refresh is a control flow component that can be used to refresh Excel Power Query and Power Pivot tables in SSIS.

Included in:

Community

Standard

Pro

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

Included in:

Community

Standard

Pro

Placeholder_Image File Properties Task

File Properties Task is an SSIS task that additionally saves drive space by identifying old files ready for archive.

Included in:

Community

Standard

Pro

Placeholder_Image HTTP Download File Task

Download File Task is used for downloading files with the HTTP protocol from within SSIS.

Included in:

Community

Standard

Pro

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

Included in:

Community

Standard

Pro

Placeholder_Image Timer Task

Timer Task is an SSIS component that allows the user configure options to pause the processing of packages.

Included in:

Community

Standard

Pro

Placeholder_Image USPS Address Verification

The USPS Address Verification component can accept address information and validate it against the USPS database.

Included in:

Community

Standard

Pro

Placeholder_Image Dimension Merge SCD Transform

Dimension Merge SCD is an SSIS component designed to handle most dimension loading scenarios with few clicks in-memory. Experience loading a dimension up to 700 times faster in SSIS!

Included in:

Community

Standard

Pro

Placeholder_Image Fact Table Destination

Fact Table Destination can greatly reduce development time for SSIS packages with multiple dimension lookups.

Included in:

Community

Standard

Pro

Placeholder_Image Rest Source

This new component allows users to connect to a web service that utilizes a REST API and extract data in XML, or Json format.

Included in:

Community

Standard

Pro

Placeholder_Image Salesforce.com Destination

With this SSIS component you will be able to very easily add data from your system into your salesforce.com account with very little configuration.

Included in:

Community

Standard

Pro

Placeholder_Image Salesforce.com Source

SalesForce.com Source is an SSIS component that easily retrieves data stored in your salesforce.com account with a few simple clicks.

Included in:

Community

Standard

Pro

Placeholder_Image Upsert Destination

Upsert Destination is an SSIS component that helps synchronize two systems no matter the source or destination.

Included in:

Community

Standard

Pro

Placeholder_Image Azure ML Storage Destination

A data flow component used to send data to an azure blob storage file that will be consumed by an Azure ML Scoring/Predication Web Service.

Included in:

Community

Standard

Pro

Placeholder_Image Azure ML Storage Source

A data flow component used to retrieve the results of a scoring/prediction Azure ML Web Service execution.

Included in:

Community

Standard

Pro

Placeholder_Image Facebook Source

Use SSIS to connect to a Facebook account and extract information.

Included in:

Community

Standard

Pro

Placeholder_Image Hadoop Web HDFS Source

Hadoop Web HDFS Source allows users to connect to a Hadoop Web HDFS instance and retrieve the contents of large text files. Data is easily parsed into columns in SSIS and streamed into the data flow.

Included in:

Community

Standard

Pro

Placeholder_Image LinkedIn Source

Use the LinkedIn Source connector to gather LinkedIn users' information.

Included in:

Community

Standard

Pro

Placeholder_Image Marketo Destination

A new data flow component that connects to the Marketo automated marketing software and allows users to insert, upsert, update, delete, and duplicate data such as Leads and Opportunities.

Included in:

Community

Standard

Pro

Placeholder_Image Marketo Source

A new data flow component used to connect to and retrieve objects such as leads and opportunities for users that employ the Marketo automated marketing software.

Included in:

Community

Standard

Pro

Placeholder_Image Microsoft Dynamics CRM Destination

Dynamics CRM Destination will allow users to insert, update, upsert and delete data from a Dynamics CRM Server within their SSIS package.

Included in:

Community

Standard

Pro

Placeholder_Image Microsoft Dynamics CRM Source

Dynamics CRM Source will allow users to retrieve data from a Dynamics CRM Server within their SSIS package.

Included in:

Community

Standard

Pro

Placeholder_Image SharePoint Destination

SharePoint List Destination Adapter allows users to quickly connect to their SSIS packages to SharePoint servers to send data to lists.

Included in:

Community

Standard

Pro

Placeholder_Image SharePoint Source

SharePoint List Source Adapter allows users to quickly connect to their SSIS packages to SharePoint servers to retrieve lists and view data.

Included in:

Community

Standard

Pro

Placeholder_Image Twitter Source

Twitter Source allows you to connect SSIS to Twitter to gain followers' information.

Included in:

Community

Standard

Pro

Placeholder_Image Address Parse Transform

Address Parse Transform is an SSIS component that contains data elements, including unformatted address data into USPS standardized address data.

Included in:

Community

Standard

Pro

Placeholder_Image Advanced Aggregator Transform

Advanced Aggregator Transform extends the base functionality of aggregate functions in SSIS to allow expression based aggregation.

Included in:

Community

Standard

Pro

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.

Included in:

Community

Standard

Pro

Placeholder_Image Case Transform

Case Transform is a transform that allows the user to format the case of source data using different styles of formatting.

Included in:

Community

Standard

Pro

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.

Included in:

Community

Standard

Pro

Placeholder_Image Data Flow Nugget

Data Flow Nugget Transform brings the ability to setup a single SSIS package with business or data rules that can be reused across several packages.

Included in:

Community

Standard

Pro

Placeholder_Image Email Source

SSIS Email Source Adapter reads email from a mailbox into a data flow.

Included in:

Community

Standard

Pro

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.

Included in:

Community

Standard

Pro

Placeholder_Image Excel Source

Excel Source uses OpenXML to read an Excel worksheet and send rows into a data flow.

Included in:

Community

Standard

Pro

Placeholder_Image Excel Destination

Excel Destination supports writing data flows into Excel files using the OpenXML format.

Included in:

Community

Standard

Pro

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.

Included in:

Community

Standard

Pro

Placeholder_Image Filter Rows Transform

Filter Rows Transform is an SSIS component that allows you to filter rows based on an expression.

Included in:

Community

Standard

Pro

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.

Included in:

Community

Standard

Pro

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.

Included in:

Community

Standard

Pro

Placeholder_Image Pack Data Transform

Pack Data Transform allows developers to use multiple relational inputs to pack or store multiple column and row values within a single destination column in SSIS.

Included in:

Community

Standard

Pro

Placeholder_Image Regex Replace Transform

RegEx Replace Transform is an SSIS component that allows the user to define a regular expression to either replace or extract data from a source column.

Included in:

Community

Standard

Pro

Placeholder_Image Replace Unwanted Characters Transform

SSIS Replace Unwanted Characters Transform allows the user to remove unwanted characters or words from source data.

Included in:

Community

Standard

Pro

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.

Included in:

Community

Standard

Pro

Placeholder_Image Terminator Destination

Terminator Destination is an SSIS component that allows you to quickly add a destination to your package without any configuration.

Included in:

Community

Standard

Pro

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.

Included in:

Community

Standard

Pro

Placeholder_Image Trim Plus Transform

Trim Plus 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.

Included in:

Community

Standard

Pro

Placeholder_Image Unpack Data Transform

Unpack Data Transform allows users to take packed /stuffed XML or delimited text data from a source column and parse it out into separate user defined columns in SSIS.

Included in:

Community

Standard

Pro

Placeholder_Image XML Destination

XML Destination is an SSIS component that allows the user to export source data to an XML File.

Included in:

Community

Standard

Pro

Placeholder_Image XML Generator Transform

XML Generator Transform gives SSIS developers the ability to map XML Schemas to columns from one or more source inputs to generate complex XML documents.

Included in:

Community

Standard

Pro

Placeholder_Image XML Output Destination

XML Output Destination is an SSIS component that was created for writing XML files that use large datasets.

Included in:

Community

Standard

Pro

Placeholder_Image Advanced Conditional Spilt Transform

Advanced Conditional Split extends and replaces the native SSIS Conditional Split to allow you to use our expanded Expression Engine.

Included in:

Community

Standard

Pro

Placeholder_Image Advanced Lookup Transform

Advanced Lookup Transform is an SSIS component that supports all the functionality of the native lookup without writing a query.

Included in:

Community

Standard

Pro

Placeholder_Image Delete Batch Transform

Delete Batch Transform is an SSIS component that allows you to easily delete data in a table without writing any SQL statements.

Included in:

Community

Standard

Pro

Placeholder_Image Oracle Upsert Destination

Oracle Upsert Destination will allow users to easily insert and update data into an Oracle table within their SSIS package.

Included in:

Community

Standard

Pro

Placeholder_Image Update Batch Transform

Update Batch Transform is an SSIS component that allows you to easily update data in a table without writing any SQL statements.

Included in:

Community

Standard

Pro

Placeholder_Image Data Validation Transform

Data Validation Transform is an SSIS component that verifies that your data is clean prior to insertion.

Included in:

Community

Standard

Pro

Placeholder_Image Advanced Lookup Cache

The "Advanced Lookup Cache Connection Manager" is used to setup the cache database as well as configure how data will be retrieved from it. Used with Advanced Lookup Cache Transform and Advanced Lookup Transform.

Included in:

Community

Standard

Pro

Placeholder_Image Azure Storage

The "Azure Storage Connection Manager" is used to connect to an Azure Machine Learning blob storage.

Included in:

Community

Standard

Pro

Placeholder_Image Dynamics CRM

Used with Dynamics CRM Destination and Dynamics CRM Source.

Included in:

Community

Standard

Pro

Placeholder_Image Email

Used with Advanced Email and SMS Task , Email Source and Email Source Delete or Move Message Task.

Included in:

Community

Standard

Pro

Placeholder_Image Excel

This connection manager is used by the Excel Source and Excel Destination components. Both components are located in the data flow. To select a file, click the ellipsis, navigate to, and select the Excel file.

Included in:

Community

Standard

Pro

Placeholder_Image Hadoop WebHDFS

Used with Hadoop WebHDFS Source.

Included in:

Community

Standard

Pro

Placeholder_Image Marketo

Used with the Marketo Source and Marketo Destination data flow components.

Included in:

Community

Standard

Pro

Placeholder_Image REST Source and Destination

Allows you to import and export data from any web service that uses a Rest API.

Included in:

Community

Standard

Pro

Placeholder_Image Rest Source OAuth

Used with the Rest Source data flow component.

Included in:

Community

Standard

Pro

Placeholder_Image Rest Source OAuth2

Used with the Rest Source data flow component.

Included in:

Community

Standard

Pro

Placeholder_Image SalesForce.com

Used with SalesForce.com Source and SalesForce.com Destination.

Included in:

Community

Standard

Pro

Placeholder_Image Secure FTP

The "SFTP Connection Manager" is used to create a connection manager with an SFTP site. Used with Secure FTP Task.

Included in:

Community

Standard

Pro

Placeholder_Image SharePoint

The "SharePoint Connection Manager" is used to set up a connection to a SharePoint server. Used with SharePoint Source and SharePoint Destination. The SharePoint Documents Task requires the similar SharePoint Documentation Connection Manager.

Included in:

Community

Standard

Pro

Placeholder_Image Social OAuth

The "Social OAuth Connection Manager" is used to set up a connection to social media sites. This connection manager is used within the Facebook Source, LinkedIn Source, and Twitter Source components.

Included in:

Community

Standard

Pro

Placeholder_Image Survey Monkey

Survey Monkey is a great tool for getting useful information and keeping in touch with clients.

Included in:

Community

Standard

Pro

Placeholder_Image Litmos

Pragmatic Works has done a series of blogs and videos discussing how our Task Factory REST Source can help you easily get the data you need from web services, such as Salesforce, GoToWebinar and Google Analytics. Here, we want to show how REST Source helped our Training Director, Devin Knight, with Litmos.

Included in:

Community

Standard

Pro

Placeholder_Image Zendesk

Learn how to connect to Zendesk's API web esrvice to pull data using the Task Factory REST Source.

Included in:

Community

Standard

Pro

Placeholder_Image GOOGLE ANALYTICS

We get it, you’ve got tons of data in external sources, such as Google Analytics, and it’s time consuming to dig through to get the data you need to make decisions for your business. Wouldn’t it be great to have the information you need gathered for you in one place?

Included in:

Community

Standard

Pro

Placeholder_Image GOTOWEBINAR

See how to configure SSIS to load registration data from GoToWebinar.

Included in:

Community

Standard

Pro

Placeholder_Image SALESFORCE

Everyone in business is looking to save time in their day and make it easier to work with the data they need to make decisions. REST Source is a component inside our Pragmatic Works’ Task Factory Suite which will automate the process of connecting to Web Services to pull information down into your SQL platform.

Included in:

Community

Standard

Pro


Compare Editions
  • Placeholder_Image

    Connectivity

    Stay connected to all of your data and pull information using SSIS from platforms such as Hadoop, SharePoint, Salesforce, Facebook, Twitter, REST Endpoints and much more!

    Learn More
  • Placeholder_Image

    Productivity

    Increase productivity and decrease development time by eliminating the need to program custom tasks using our efficient components.

    Learn More
  • Placeholder_Image

    Performance

    Task Factory components are optimized to run much faster than the native SSIS components.

    Learn More
  • Placeholder_Image

    Data Warehouse

    SSIS components designed to easily load and manage your data warehouse.

    Learn More
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
Standard
$1495
Per server
Buy
Pro
$1995
Per server
Buy
USPS Address Verification Add-On
$1995
Annually
  • Must have Task Factory Pro to use USPS Address Verification feature.
  • Auto-renew option available.
Buy

Frequently Asked Questions

  • How is Task Factory licensed?

    Task Factory is licensed per server instance. There is no license necessary to use Task Factory in the Integration Services development environment (Visual Studio, SQL Server Data Tools, or Business Intelligence Developer Studio). Please contact sales@pragmaticworks.com for more information.

  • Does Task Factory support Salesforce TLS 1.2?

    Yes, but in order to continue using the Salesforce features, you must upgrade to the latest version of Task Factory. Click here for more information on Salesforce's upgrade to TLS 1.2.

  • What are the system requirements for Task Factory?

    • SQL Server Integration Services 2008, 2012, 2014 or 2016
    • BIDS 2005 or 2008 (Business Intelligence Development Studio) or SQL Server Data Tools 2012, 2014, or 2016 (for Visual Studio 2015)
    • Windows XP or later
    • Windows Server 2000 or later
  • What functions are available with Task Factory?

    There are a number of functions available with Task Factory. Click here to view a complete list.

  • Can Task Factory be used with Azure?

    Yes, Task Factory components can be used with Azure databases.