SolarWinds Task Factory

By SolarWinds Task Factory

Add high-performance components and connectors to SQL Server Integration Services for faster ETL development.

SSIS ComponentsETL ToolsData IntegrationSQL Server
Overview

What is SolarWinds Task Factory?

SolarWinds Task Factory is a suite of components for SQL Server Integration Services that extends ETL and data warehouse development. It adds sources, destinations, and transforms such as Upsert, Slowly Changing Dimensions, REST and Salesforce connectors, SFTP, file encryption, compression, and email sources. Components install into Visual Studio and run inside SSIS packages. BI developers, data engineers, and SQL Server DBAs use SolarWinds Task Factory to reduce custom scripting and build packages faster.

Best for
BI DevelopersData EngineersSQL Server DBAsData Warehouse TeamsETL Developers
Product snapshot
Category
Data Extraction & Collection
Best for
SSIS ETL development
Deployment
Cloud / On-premise
Free trial
Yes
Integrations
Salesforce, REST APIs, SFTP
AI features
No
Key features

Key features of SolarWinds Task Factory

Upsert destination

Insert or update rows in one step without complex lookup logic.

Slowly changing dimensions

Manage dimension history in data warehouses with a dedicated transform.

Salesforce connectors

Read from and load data into Salesforce directly within SSIS.

REST source

Pull data from web APIs without writing custom script tasks.

Secure file handling

Transfer files over SFTP and encrypt, sign, or compress them.

Email source adapter

Extract messages and attachments filtered by sender, date, or subject.

Reviews

SolarWinds Task Factory reviews

20 reviews

Overall

4.6/5

  • Ease of use4.4/5
  • Features4.4/5
  • Value for money4.5/5
  • Customer support4.6/5

What users like

  • Cuts SSIS development time
  • Fast Upsert and lookup components
  • Easy Salesforce and SFTP connectivity
  • Responsive and helpful vendor support

What users dislike

  • Documentation lacks real-world examples
  • Separate license needed for testing
  • Some components can feel slow
  • Learning curve for advanced components

Jennyfer R.

SQL Database Administrator/Developer

“Liked the many extra SSIS tasks, which allowed replacing a Linux scripting server. Found it hard at times to identify which feature fits a particular need.”

Verified Reviewer

Data Architect

“Liked the easy setup, many connectors, free development license, and responsive support. Found it lacking file transfer options for cloud storage services.”

Floris Jan G.

ICT Specialist

“Liked how easy it is to use and the quick integration with Salesforce. Found that automatic column matching can break existing data flows.”

Mathew M.

SQL Server DBA/Developer

“Liked that components run much faster than built-in ones, especially Upsert and cache lookups. Found support replies slow and the Slowly Changing Dimension component hard to learn.”

Write a review

Sign in with your account to review SolarWinds Task Factory.

Sign in to review
Alternatives

Top SolarWinds Task Factory alternatives

  • KingswaySoft

    Best for

    SSIS application connectors

    Why choose it

    Large SSIS connector library for business apps

  • COZYROC SSIS+

    Best for

    SSIS task extensions

    Why choose it

    Broad set of SSIS tasks and components

  • CData SSIS Components

    Best for

    SSIS data source connectors

    Why choose it

    Standard connectors for hundreds of data sources

  • ZappySys SSIS PowerPack

    Best for

    SSIS REST and cloud

    Why choose it

    Strong REST, JSON, and cloud storage components

Integrations

SolarWinds Task Factory integrations

SolarWinds Task Factory installs into SQL Server Data Tools and Visual Studio, adding components directly to the SSIS toolbox. Its connectors cover Salesforce for reading and loading records, REST and web APIs, SFTP and FTP servers, SharePoint, Azure services, and email inboxes through a dedicated email source. Additional third-party connectors include Mailchimp, Facebook, Zendesk, and GoToWebinar. File tasks handle PGP encryption, decryption, signing, and compression, while an Excel source reads existing workbooks. Destinations such as Upsert and dimension merge load data into SQL Server warehouses. Packages built with these components run wherever SSIS runs, including on-premise servers and Azure-SSIS environments.

FAQ

Frequently asked questions about SolarWinds Task Factory