Task Factory Installation

Download: For more information about Task Factory pricing or downloading a trial, see the Task Factory product page.

Additional Information:

Installing Task Factory

Installing Task Factory

Complete the following steps to install Task Factory:

1. Start the Task Factory installer by running the TaskFactory.exe file. Select your install destination from the drop-box, then select the checkbox to agree to the license terms and conditions. Select Next to continue.

SentryOne Task Factory Installer

2. Select the Typical or Custom setup type, then select install.

Note:  The Typical setup is recommended for most customers.

Important:  If you choose the Custom installation for the 2016 version, you must include the 2012 and 2014 installations (which are selected by default).

SentryOne Task Factory Typical setup
Typical Install

SentryOne Task Factory Custom setup
Custom Install
SentryOne Task Factory Custom Setup components
Select Custom Components

Note:  The installation process may take several minutes. You can monitor the status through the installer.

SentryOne Task Factory Installation status

3.  After the installation is complete, the confirmation window displays. Select Finish to complete the installation.

SentryOne Task Factory Installation select Finish

Additional Information: If your Task Factory components aren't displaying in the SSIS toolbox after installation, you may not be targeting a supported version of SSIS. See the Task Factory Items not showing up tab in the Common Errors article for more information.

Adding Task Factory Components in BIDS/Visual Studio 2010 or lower

Before you can use the Task Factory components in BIDS, you must add them to your toolbox. 

Note:  Adding Task Factory components in BIDS is not necessary with SQL Server Data Tools (2012 or higher).

Complete the following steps to add the Task Factory components to your toolbox:

  1. Open an SSIS package, then open your toolbox (View > Toolbox).
  2. Right click the toolbox window and select Choose Items...Add Task Factory components to your toolbox
  3. Select the SSIS Control Flow Items tab and select all deselected tasks that begin with TF. Next, follow the same step with the SSIS Data Flow Items tab.
  4. After you have selected all Task Factory Control Flow and Data Flow items, select OK to save and confirm your selections. Add Task Factory Components to your toobox
Installing Task Factory on Azure

Installing Task Factory on Azure

These instructions walk through the steps to create an Azure SSIS Integration Runtime (IR) and install SentryOne Task Factory during the start-up process of the Integration Runtime.

System Requirements

You need the following prerequisites to set up Task Factory for your Azure Data Factory SSIS Integration Runtime:

  • Azure subscription
  • Azure SQL Database or Managed Instance Server
  • Microsoft Azure Storage ExplorerEdition Restrictions

The following components are incompatible on an Azure Data Factory SSIS Integration Runtime:

Note:  Currently, there isn’t a trial version of Task Factory to run on Azure Data Factory SSIS Integration Runtime because of the way the IR handles the installation and licensing for third-party components.

Important:  Before activating your Task Factory license, you need to obtain an ADF-ready license from the SentryOne sales department. You can contact them at sales@sentryone.com. Select the license based on the number of nodes in your SSIS Integration Runtime.

Configuring Task Factory on Azure SSIS Integration Runtime

  1. Configure your settings on the Initial Integration runtime setup screen, and then continue to Advanced settings.Task Factory Azure SSIS Integration runtime setup SQL Settings
  2. Select the Customize your Azure-SSIS Integration Runtime with additional system configurations/components installations checkbox, and then select the +New link under Express custom setup to open the Add express custom setup window.Task Factory Azure SSIS Integration runtime setup Advanced Settings
  3. Select Install licensed component from the drop-down list, and then select Task Factory.Task Factory Azure SSIS Integration runtime setup Add express custom setup
  4. Paste your Task Factory License key into the License Key box to complete the configuration. Task Factory Azure SSIS Integration runtime setup Add express custom setup enter license key

Success: Every time you start your Integration Runtime, each node will have Task Factory automatically installed and activated without any further steps from you.

Creating Your Data Factory

Additional Information: Use the SAS URL you created as you go through the Provision the Azure-SSIS Integration Runtime in Azure Data Factory MSDN tutorial. The specific step you use the URL on is Step Four (Advanced Settings).

Note:  The tutorial doesn’t mention that you need an Azure SQL Server instance that doesn’t have an SSISDB database on it. If you have an SSISDB database on the SQL Server you provide during the process of creating your Azure IR , the IR creation process fails.

Every time you want to create an SSIS IR, you need to delete the current SSISDB or create a new server without an SSISDB database.

Follow the tutorial to set up your Data Factory and Azure SSIS IR instance.

After you have created the Data Factory, log directories are created in your blob storage container. Log files are located under the main.cmd.log directory. If you had Storage Explorer open already, you might need to refresh the window.

Review the log files for any errors. If you don’t see any errors, you’re good to go.

Note:  You shouldn’t need to review the Task Factory installation log unless you run a package with Task Factory and receive a specific Task Factory failure message.

Deploying Packages to Azure SSIS IR   

Now that your Azure IR has been created and Task Factory is installed, you should be able to take any package created locally in SSDT, deploy it to Azure IR, and execute it successfully.

Additional Information: To deploy your packages to your Azure IR, follow the Deploy and run a SQL Server Integration Services (SSIS) package in Azure MSDN tutorial.

Note:  You must have the latest version of SQL Server Management Studio 17.2 or above installed to follow the tutorial and view the Integration Service Catalog.

If you encounter any issues while installing or activating Task Factory in your Azure SSIS IR, contact our support team at support.sentryone.com.