Task Factory

Dozens of new SSIS components for your toolbox. Prices Starting at $1495

    Add To Cart Free Trial Download

Generate database and BI documentation quickly and efficiently. Document your database, SSAS cubes, SSIS packages and SSRS reports Trace the source of your data with Object Lineage and track how changes to one part of your environment will affect other areas with Impact Analysis Generate documents from point in time snapshots Customize your documentation output Schedule snapshots and documentation from the command line DOC xPress produces complete documentation for SQL Server instances. In addition, it enables documentation for Analysis Services (SSAS), Integration Services (SSIS) and Reporting Services (SSRS). Snapshots of the environment can be captured with a few clicks, making it easy to capture what an environment looks like before making changes. Documentation can be produced from any daily snapshot, allowing users to see what the environment looked like in the past. The snapshot and the documentation processes can be scheduled using the command line, allowing integration with popular scheduling utilities. The contents of the documentation can be customized, both for what is included in the output, as well as the templates to use for each type of object. Speed up your documentation efforts with DOC xPress!

Task Factory Features

Fact Table Destination

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

Learn More

Dimension Merge SCD

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

Learn More

Upsert Destination (Batch Update Or Insert)

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

Learn More

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. 

Learn More

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.

Learn More

SharePoint Documents Task

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

Learn More

Oracle Upsert Destination

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

Learn More

Address Parse Transform

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

Learn More

Advanced Derived Column

Advanced Derived Column extends and replaces the native SSIS Derived Column to allow the user to use our expanded Expression Engine.

Learn More

Advanced Conditional Split Transform

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

Learn More

Advanced Aggregator Transform

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

Learn More

Filter Rows Transform

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

Learn More

Advanced Lookup Transform

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

Learn More

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.

Learn More

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.

Learn More

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.

Learn More

SharePoint Source

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

Learn More

SharePoint Destination

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

Learn More

Secure FTP Task

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

Learn More

Compression Task (Zip or Unzip)

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

Learn More

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.

Learn More

SSIS Email Source Adapter

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

Learn More

Data Validation Transform

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

Learn More

File Properties Task

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

Learn More

Timer Task

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

Learn More

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.

Learn More

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.

Learn More

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.

Learn More

Advanced Email and SMS Task

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

Learn More

Terminator Destination

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

Learn More

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.

Learn More

SSIS Replace Unwanted Characters Transform

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

Learn More

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.

Learn More

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.

Learn More

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.

Learn More

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.

Learn More

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.

Learn More

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.

Learn More

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.

Learn More

Download File Task

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

Learn More

Data Flow Nugget

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

Learn More

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.

Learn More

XML Output Destination

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

Learn More

XML Destination

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

Learn More

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.

Learn More

Dynamics CRM Source

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

Learn More

SQL Server 2014 Support

This product is now compatible with SQL Server 2014.

Learn More

Some of our clients