x

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 50 components, Task Factory can increase productivity, improve performance and increase your ROI.

Watch 2 Minute Intro Video

Key Features and Benefits


Helpful Links

Priced From $1495-$1995

Productivity

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

Learn More

Performance

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

Learn More

Data Warehouse

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

Learn More
Feature CommunityFree Standard$1,495 - Per Server Pro$1,995 - Per Server
Most Popular
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!
Fact Table Destination
Fact Table Destination can greatly reduce development time for SSIS packages with multiple dimension lookups.
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.
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.
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.
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.
Upsert Destination
Upsert Destination is an SSIS component that helps synchronize two systems no matter the source or destination
Connectivity
Azure ML Batch Execution Task
A control flow component that control 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.
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.
Azure ML Storage Source
A data flow component used to retrieve the results of a scoring/prediction Azure ML Web Service execution.
Facebook Source
Use SSIS to connect to a Facebook account and extract information.
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.
LinkedIn Source
Use the LinkedIn Source connector to gather LinkedIn users' information.
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.
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.
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.
Microsoft Dynamics CRM Source
Dynamics CRM Source will allow users to retrieve data from a Dynamics CRM Server within their SSIS package.
SharePoint Destination
SharePoint List Destination Adapter allows users to quickly connect to their SSIS packages to SharePoint servers to send data to lists.
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.
SharePoint Source
SharePoint List Source Adapter allows users to quickly connect to their SSIS packages to SharePoint servers to retrieve list and view data.
Twitter Source
Twitter Source allows you to connect SSIS to Twitter to gain followers' information.
Productivity
Address Parse Transform
Address Parse Transform is an SSIS component that contains data elements, including unformatted address data into USPS standardized address data.
Advanced Aggregator Transform
Advanced Aggregator Transform extends the base functionality of aggregate functions in SSIS to allow expression based aggregation.
Advanced Derived Column
Advanced Derived Column extends and replaces the native SSIS Derived Column to allow the user to use our expanded Expression Engine.
Advanced Email and SMS Task
Advanced Email and SMS Task sends emails from within an SSIS package through SMTP.
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.
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.
Case Transform
Case Transform is an SSIS component that provides a way to properly case, uppercase or lowercase all the text in a source column.
Compression Task
Compression Task will compress files within SSIS by up to 90%, allowing greater speed and less network space.
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.
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.
Data Validation Transform
Data Validation Transform is an SSIS component that verifies that your data is clean prior to insertion.
Email Source
SSIS Email Source Adapter reads email from a mailbox into a data flow.
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.
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.
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.
File Properties Task
File Properties Task is an SSIS task that additionally saves drive space by identifying old files ready for archive.
Filter Rows Transform
Filter Rows Transform is an SSIS component that allows you to filter rows based on an expression.
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.
HTTP Download File Task
Download File task is used for downloading files with the HTTP protocol from within SSIS.
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.
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.
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.
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.
Replace Unwanted Characters Transform
SSIS Replace Unwanted Characters Transform allows the user to remove unwanted characters or words from source data.
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.
Terminator Destination
Terminator Destination is an SSIS component that allows you to quickly add a destination to your package without any configuration.
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.
Timer Task
Timer Task is an SSIS component that allows the user configure options to pause the processing of packages.
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.
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.
XML Destination
XML Destination is an SSIS component that allows the user to export source data to an XML File.
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.
XML Output Destination
XML Output Destination is an SSIS component that was created for writing XML files that use large datasets.
Performance/Data Warehouse
Advanced Conditional Spilt Transform
Advanced Conditional Split extends and replaces the native SSIS Conditional Split to allow you to use our expanded Expression Engine.
Advanced Lookup Transform
Advanced Lookup Transform is an SSIS component that supports all the functionality of the native lookup without writing a query.
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.
Oracle Upsert Destination
Oracle Upsert Destination will allow users to easily insert and update data into an Oracle table within their SSIS package.
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.

Contact us to schedule Live Product Demos

(904) 413-1911

Send Email

FAQs

View All FAQs In Support

How are LegiTest and LegiTest Server licensed?

LegiTest is licensed per user, per machine where it is used. LegiTest Server is licensed per server instance, with unlimited client access licenses. Please contact sales@pragmaticworks.com for more information.

How is DTS xChange licensed?

DTS xChange is licensed per package conversion. Please contact sales@pragmaticworks.com for more information.

How is DBA xPress licensed?

DBA xPress is licensed per user, per machine where it is used. Please contact sales@pragmaticworks.com for more information.

How are BI xPress and BI xPress Server licensed?

BI xPress is licensed per user, per machine where it is used. BI xPress Server is licensed per server instance with 5 client access licenses included. A client access license is assigned to a single user. Additional client access licenses can be purchased. Please contact sales@pragmaticworks.com for more information.

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.

How are DOC xPress and DOC xPress Server licensed?

DOC xPress is licensed per user, per machine where it is used. DOC xPress Server is licensed per server instance with 5 client access licenses included. A client access license is assigned to a single user. Additional client access licenses can be purchased. Please contact sales@pragmaticworks.com for more information.

Does DOC xPress support encrypted packages and passwords?

Yes, DOC xPress supports SSIS projects and ISPAC that encrypt passwords. It also supports encrypted SSIS packages.

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 versions of Visual Studio is LegiTest compatible with?

LegiTest is only compatible with Visual Studio 2012 or 2013. If you are running on an older version, you will need to upgrade.

I already have testing software in place. Why do I need LegiTest?

Most testing software only tests certain aspects of data-centric development. LegiTest allows testing across all aspects of your development lifecycle, providing validation at each stage of development

Will LegiTest work with the systems I already have in place?

Yes. LegiTest easily integrates with existing systems. It can be incorporated into build processes such as MSBuild, TFS, TeamCity and much more.

Why should I care about testing?

Testing your data ensures you catch bugs early, reduce delivery time, reduce the cost of testing and provides provable assurances of the validity of the data. But most of all, testing just works. Testing ensures accurate code, and more importantly accurate data.

What versions of SSIS does DTS xChange work with?

DTS xChange only does conversions for SSIS 2005 or 2008.

Does DTS xChange do full conversions?

In many cases it can, however it is dependent upon the contents of the existing DTS package.

How can DTS xChange save time and money?

DTS xChange uses proprietary rule based engine to migrate DTS Packages to SSIS by applying best practices of SSIS. So by using DTS xChange you not only get higher migration success rate but you also get new features supported by SSIS (e.g. Event Handlers, Logging, XML Configuration Files etc.)

What are the system requirements for DBA xPress?
  • SQL Server Integration Services 2008, 2008 R2, 2012, 2014 or 2016
  • BIDS 2005, 2008, 2008 R2 (Business Intelligence Development Studio), or SSDT 2010, 2012 (SQL Server Data Tools)
  • Microsoft ® .NET 3.5 with Service Pack 1
  • Microsoft ® .NET 4.0
  • Microsoft ® Report Viewer 2005
  • Microsoft ® SQL Server ® 2012 Transact-SQL ScriptDom x86
What is the difference between BI xPress and DBA xPress? (DBA xPress is included in the Pro version of BI xPress)

DBA xPress is a suite of tools designed to aid the DBA with the management of their SQL Servers and data. BI xPress Pro includes DBA xPress with it.

Can I view a sample document?

You can! Click here to download a sample document. Having trouble viewing CHM files? Click here for instructions on how to view them.

What are the differences between DOC xPress Pro and Server?

DOC xPress Server makes it easier to share and explore documentation across the enterprise. It eliminates the need to install DOC xPress Pro to view documentation, do lineage analysis, and update data dictionaries.

What are the system requirements for DOC xPress?
  • SQL Server Integration Services 2008, 2008 R2, 2012, 2014 or 2016
  • BIDS 2005, 2008, 2008 R2 (Business Intelligence Development Studio), or SSDT 2010, 2012 (SQL Server Data Tools)
  • Microsoft ® .NET 3.5 with Service Pack 1
  • Microsoft ® .NET 4.0
  • Microsoft ® SQL Server ® 2012 Transact-SQL ScriptDom x86
Can I customize the way my documentation works?

The DOC xPress and DOC xPress Server templates are used to lend form and reason to the output. They are fully customizable and control what information is included in the documentation. For more information, click here.

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 or 2014)
  • 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.

Can I get just one feature of BI xPress and not purchase the entire product?

BI xPress comes bundled and there is no way to only sell one feature of the product.

Can I make custom templates for the Notification Framework?

Yes, you can designate the reason for the message to go out and make your own custom message that you can share with others.

What are the system requirements for BI xPress?
  • SQL Server Integration Services 2008, 2008 R2, 2012, 2014 or 2016
  • BIDS 2005, 2008, 2008 R2 (Business Intelligence Development Studio), or SSDT 2010, 2012 (SQL Server Data Tools)
  • Microsoft ® .NET 3.5 with Service Pack 1
  • Microsoft ® .NET 4.0
  • Microsoft ® Report Viewer 2005
  • Microsoft ® SQL Server ® 2012 Transact-SQL ScriptDom x86
What are the differences between BI xPress Pro and Server?

BI xPress Server provides the ability to monitor SSIS package execution as well as Reporting Services, making it easier to provide access to this information without the need to install the full BI xPress Pro software.