SolarWinds Task Factory

About SolarWinds Task Factory
Task Factory is a data integration tool designed to help businesses utilize SQL Server Integration Services (SSIS) components to improve extract, transform, load (ETL) processes. The Secure FTP Task supports Secure Shell Protocol (SSH), Hypertext Transfer Protocol (HTTP), and SOCKet Secure (SOCKS4) protocols whilst allowing organizations to transmit files across various channels.
Task Factory's SSIS Email Source Adapter filters emails based on sender, subject, date, body or priority and supports Internet Message Access Protocol (IMAP), Post Office Protocol (POP3), and more. Data Validation Transform collects and verifies phone numbers, email addresses, and Social Security numbers (SSN), among other information from various sources. Businesses can also manage and load data warehouses and utilize the Task Factory Azure Data Factory edition to run SSIS packages in the cloud.
Using Task Factory's REST API, businesses can connect and extract data from any cloud application or web service, such as GoToWebinar, Zendesk, SurveyMonkey, Facebook, Salesforce, and more.
Key benefits of SolarWinds Task Factory
Save time on tedious ETL tasks, efficiently develop data-centric apps, and connect to cloud data sources with SolarWinds Task Factory.
Images



Not sure about SolarWinds Task Factory?
Compare with a popular alternative
Starting Price
Pricing Options
Features
Integrations
Ease of Use
Value for Money
Customer Service
Alternatives
Adverity

Supermetrics

Hevo

Jaspersoft

Reviews
Already have SolarWinds Task Factory?
Software buyers need your help! Product reviews help the rest of us make great decisions.

- Industry: Construction
- Company size: 1,001–5,000 Employees
- Used Weekly for 1+ year
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
I frequently use Task Factory in the SSIS package I create for integration between system.
Reviewed on 2017/11/02
I am able to solve problems in a single SSIS package vs using SSIS and Linux scripts.
I am able to solve problems in a single SSIS package vs using SSIS and Linux scripts.
Pros
Task Factory really expands the types of tasks that are available in SSIS. We have used Secure FTP Task, PGP task, and Advanced Email to accomplish complex scenarios that we had to use custom scripts to accomplish before. This is helping us reduce our footprint because we are phasing out a Linux server we have that used to encrypt and move files back and forth between secure FTP sites. We are able to replace everything this Linux server was doing with script with a single SSIS package thanks to the Task Factory tasks. I especially like the "TF Error Output Description" and have used it many times in troubleshoot failures. I don't know what I did before this feature! There are so many more features that Task Factory has that I'm excited to explore. When I have a problem I'm trying to solve in SSIS, my new attitude is "I bet Task Factory can do that!"
Cons
Sometimes I have trouble finding which feature will accomplish what I need. For example, I needed to have a unique number generated for each row in a flow but use the last number as the new starting number. After some investigation I found that I can easily accomplish that with the "Surrogate Key Transform" it just took me a while to figure out that was the task I needed.
- Industry: Management Consulting
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
Amazing tool!
Reviewed on 2018/02/16
Pros
Easy installation and integration to your project, user friendly controls, lots of features to connect to on-premise and cloud services. Free license for development. The customer support is very helpful and responsive.
Cons
While there is nothing much that's missing on this tool, I would also like to see something related to posting/downloading files from Cloud Storage services like GoogleDrive or Dropbox.
- Industry: Information Technology & Services
- Company size: 11–50 Employees
- Used Monthly for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 7.0 /10
With Task Factory we implemented the integration with Salesforce and other systems quick and...
Reviewed on 2017/08/10
Pros
The software is easy to use and has a lot of features. When creating SSIS flows, sometimes I am surprised to learn about a feature I didn't use before.
Cons
Sometimes the software 'thinks' a little bit too much. Changes in upstream columns trigger the automatic column matching process. Sometimes this breaks existing functionality.

- Industry: Pharmaceuticals
- Company size: 501–1,000 Employees
- Used Daily for 1+ year
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
Awesome
Reviewed on 2017/11/16
Massive speed improvement over built in Microsoft SSIS components.
Massive speed improvement over built in Microsoft SSIS components.
Pros
I've always been on the fence on third party SSIS components, due to them not being built in Microsoft products, but the Upsert Destination is amazing, and the Advanced Cache Lookup components are crazy fast. I pump at least a trillion rows a day through them.
Cons
SCD was hard to understand, and support takes a little while to get back to you, so I ended up figuring it out on my own.
- Industry: Information Technology & Services
- Company size: 51–200 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
As a heavy user of SSIS I have found Task Factory to be an essential add-on.
Reviewed on 2017/08/31
Enables me to implement a work load that would of taken much longer or required more developers.
Enables me to implement a work load that would of taken much longer or required more developers.
Pros
Massively reduces development time.
Reduces complexity of package design thus making packages easier to maintain.
Replaces many script tasks jobs for which you would have to write substantial code.
My favourite components are the Update/Upsert Tasks as they remove the need for writing a lot of SQL plumbing code.
Cons
None
Response from SolarWinds
Thank you for the feedback, Jason. We really appreciate it.
On the item you mention on Visual Studio upgrades, please note that the Visual Studio SSIS toolbox doesn't read it's information from the GAC, it uses folders under [YourSQLServerInstallFolder]\[version]\DTS. The Task Factory installer installs into this folder if it exists, but if you upgrade the version of SSIS installed, you need to reinstall TF afterward to ensure it puts the components in the newly created SSIS folders.
SolarWinds Task Factory FAQs
Below are some frequently asked questions for SolarWinds Task Factory.Q. What type of pricing plans does SolarWinds Task Factory offer?
SolarWinds Task Factory offers the following pricing plans:
- Starting from: US$1,245.00/year
- Pricing model: Subscription
- Free Trial: Available
$1,245.00 per license, per server plus $359/year required maintenance fee
Q. Who are the typical users of SolarWinds Task Factory?
SolarWinds Task Factory has the following typical customers:
Self Employed, 2–10, 11–50, 51–200, 201–500, 501–1,000, 1,001–5,000
Q. What languages does SolarWinds Task Factory support?
SolarWinds Task Factory supports the following languages:
Chinese, English, French, German, Japanese, Korean, Portuguese, Spanish
Q. Does SolarWinds Task Factory support mobile devices?
SolarWinds Task Factory supports the following devices:
Q. What other apps does SolarWinds Task Factory integrate with?
SolarWinds Task Factory integrates with the following applications:
Salesforce.org Nonprofit Cloud, SurveyMonkey, Zendesk Suite
Q. What level of support does SolarWinds Task Factory offer?
SolarWinds Task Factory offers the following support options:
Email/Help Desk, FAQs/Forum, Knowledge Base, Phone Support, 24/7 (Live rep), Chat
Related categories
See all software categories found for SolarWinds Task Factory.