Feature_Part_of-Product_Logos_Task_Factory (1)

Install & Activate Task Factory on an Azure Data Factory SSIS Integration Runtime

 

FREE TRIAL 

Here is an explanation of how to create an Azure SSIS Integration Runtime (IR) and install SentryOne Task Factory during the start-up process of the IR.

Currently, the only way to install third-party SSIS components such as Task Factory is by creating a main.cmd batch file that will run the installation and licensing commands during the start-up process of the Azure SSIS IR.

You can read more about the general process of custom start-up scripts for an Azure IR here.

Prerequisites

Edition Restrictions

  • USPS Address Verification won’t work.
  • Unless you install Excel on the ADF IR, Task Factory Excel Power Refresh Task won’t work. You can install Excel via the installation script explained below and in the link above.
  • There isn’t a trial version of Task Factory to run on ADF SSIS IR at this time because of the way the IR handles the installation and licensing for third-party components.

Create an Azure Storage Container

To get started, create a new Azure blob storage container. To do so, open Azure Storage Explorer, browse to your blob containers, right-click Blob Containers, select Create Blob Container, and name your blob.

create-blog-container

 

Set Up the main.cmd File

To set up the main.cmd file, download the latest version of Task Factory. Then, rename the installation file TaskFactory_Install.exe. Next, download the ADF Task Factory installation zip file from our public blob container by opening Azure Storage Explorer and following these steps:

  1. Under (Local and Attached), right-click Storage Accounts, select Connect to Azure Storage, select Use a connection string or a shared access signature URI, and then click Next.

    custom-setup-image9
  2. Select Use a SAS URI and enter the following Shared Access Signature (SAS) URI for the Public Preview container:

    https://pwsdownloads.blob.core.windows.net/taskfactory-adf/azure-configure-ssis-ir-taskfactory.zip?st=2018-11-06T14%3A48%3A00Z&se=2020-11-07T14%3A48%3A00Z&sp=rl&sv=2017-04-17&sr=c&sig=zQ4Bu7ka5AsosiefY0RGnrpw4PxXLfh5Dz3berixFko%3D


    C
    lick Next and then click Connect.

    custom-setup-image10

  3. Download the azure-configure-ssis-ir-taskfactory.zip file and extract the contents.

  4. Open the cmd file and replace YOUR_KEY_HERE in the command

    call PragmaticWorks.LicenseManager.Console.exe online YOUR_KEY_HERE >> %CUSTOM_SETUP_SCRIPT_LOG_DIR%\activation.log

    with your Task Factory activation key. If you don’t have your key, please contact support@sentryone.com to obtain your key.

  5. After you’ve added your key, upload your edited cmd file, TaskFactory_Install.exe, and PragmaticWorks.LicenseManager.Console.exe to your blob storage container.

Your storage container should look like the following screenshot.

storage-container-after-upload-azure-data-factory-task-factory

 

Create Your Shared Access Signature URL

For the Azure IR to be able to see the files shown in the previous screenshot, you’ll need to provide a SAS to the script.

To create your SAS, right-click the blob container you just created and select Get Shared Access Signature.

get-shared-access-container

 

You’ll be prompted with the dialog box shown below.

shared-access-signature-dialog

Select the Write option in the Permissions section. Otherwise, the installation process can’t write a log file for the main.cmd, Task Factory installation, and activation processes.

Click Create and a URL will be provided on the next screen. Copy and save that URL temporarily.

Create Your Data Factory

You’ll use the SAS URL you just created as you go through this tutorial. The specific step you’ll use the URL on is Step 4 (Advanced Settings).

Note that the tutorial doesn’t mention that you’ll 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 as you follow the tutorial, the IR creation process will fail.

Therefore, every time you want to create an SSIS IR, you need to either delete the current SSISDB (if it’s not used) or create a new server without an SSISDB database. The Microsoft tutorial assumes you’ll create a new SQL Server each time you create a new Azure SSIS IR.

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

After you have created the Data Factory, you'll see log directories created in your blob storage container. Any log files will be 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 that you shouldn’t have 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.

To deploy your packages to your Azure IR, follow this tutorial. Note that 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, please don’t hesitate to contact our support team at support@sentryone.com.

 

Free Trial TF