I’m pleased to announce that a new version of SentryOne Task Factory has been released! It is packed with new features and bug fixes—16 new features and 27 fixes, to be exact. Let’s dive into a few of the notable enhancements.

Task Factory New Features

Feature 50526: Add Support for SQL Server Integration Services 2019 and Visual Studio 2019

This enhancement speaks for itself—we now support SSIS 2019, and you’re able to access the Task Factory connection managers in SQL Server Data Tools for Visual Studio 2019. So go ahead and upgrade to the latest version of Visual Studio; I hear it has some cool new features.

Feature 47351: Add Cipher Selection to PGP Task

Task Factory’s PGP Task can be used to encrypt or decrypt a file using—you guessed it—PGP encryption. Previously, this task used Cast5 cipher exclusively. Now you’re able to select a cipher from a list of encryption/decryption methods, including TripleDes, AES128, AES192, and AES256.

Cipher Drop-Down List in Task Factory 2019.1.1

Feature 50607: Upgrade Salesforce Components to Use the New SOAP API to v45

Salesforce’s SOAP API is used to create, retrieve, update, or delete records, such as accounts, leads, and custom objects. The upgraded Task Factory Salesforce components use the latest version of this API, allowing you to continue to receive the latest functionality Salesforce has to offer.

Feature 49596: Salesforce Source Supports Nested Queries

More Task Factory Salesforce component improvements. Yay!

When using Task Factory’s Salesforce Source, you can now nest queries when retrieving data from Salesforce.com (as shown in the screenshot below), which helps save time by avoiding unnecessary refactors to your query.

Nest Queries When Retrieving Data From Salesforce.com

Feature 47214: Email Source Has the Option to Download All Attachments to a Single Directory

Before this release, the Email Source component downloaded attachments into a new folder. Depending on your use case, this might be fine—but what if you have a specific directory you’d like to use for your downloaded files (which I’m sure most of us do)? We heard your feedback and made changes to improve this experience. New configuration options give you the ability to download an attachment directly into a specified directory.

Task Factory Fixes

Bug 53029: Salesforce ‘operation has timed out’ Error with Two Bulk Data Flows

This issue occurred when two sequential data flows (meaning two data flows, one immediately after the other) connected to Salesforce using Bulk source or destination. Any third data flow that is after the two sequential Bulks in the package that connects to Salesforce would time out during validation.

Bug 46894: Advanced Execute Package—Urn Could Not Be Resolved When Using 'out of process' Execution Mode

This error affected the Advanced Execute Package Task after upgrading servers from SQL Server 2012 to SQL Server 2017.

Bug 51369: Salesforce Source Tool Unexpectantly Changing Dates When Pulling 'date' Values in Local Time

When specifying the ‘Output Date As’ field to reflect the local time (as opposed to UTC) in the Salesforce Source, the date would change to one day prior. This issue has been corrected, and although it might seem like this was a bug, it was actually our first attempt at time travel services.

This release also includes a fix related to an intermittent timeout error when using Dynamics CRM components, as well as significant performance enhancements when using the Salesforce source.

How to Upgrade to the Latest Version of Task Factory

We want everyone to get their hands on the latest version of Task Factory. If you’re new to SentryOne, welcome!

To download a free Task Factory license that allows you to execute packages with Task Factory components within BIDS, SSDT, and Visual Studio forever—yeah, I said forever—click here.

Already use Task Factory? You can upgrade to the latest version of Task Factory in three easy steps:

1. Download the new Task Factory release from sentryone.com
2. Uninstall the previous version of Task Factory through the Windows Control Panel
3. Install the new Task Factory release

As a best practice, it’s always a good idea to create a backup of any projects using the old version of the Task Factory, in case you ever need to revert.

If you have any questions about upgrading to the latest version of Task Factory, feel free to give us a shout on the SentryOne support page, or refer to the installation instructions in our help documentation You can also view the Task Factory Release Notes here).

Please send me your feedback!

-Tyler