Upsert destination
Insert or update rows in one step without complex lookup logic.
Add high-performance components and connectors to SQL Server Integration Services for faster ETL development.
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.
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.”
Jason B.
BI Developer
“Liked how much it cuts development time and reduces package complexity in SSIS projects. Noted no major drawbacks with the product.”
Jason K.
Director of Data Management
“Liked the easy SFTP and PGP encryption enhancements for file handling. Found web API support and JSON and XML handling in need of improvement.”
Verified Reviewer
Senior Decision Support Analyst
“Liked the drag-and-drop components that replace custom scripts. Found the documentation thin and some components missing features that would be expected.”
Dylan T.
AIX Systems Administrator
“Liked how much time it saves and the improved quality of output. Found the lack of an MSI installer inconvenient and hit a null-date bug the vendor acknowledged.”
Wojciech J.
BI Developer
“Liked the faster delivery and support for REST and flexible Excel sources. Found configuration tabs slow to respond and the documentation in need of more depth.”
Eric S.
VP Database Development
“Liked the server-based licensing and responsive support and sales teams. Found a recurring note pushing an edition upgrade, with drawbacks otherwise unclear.”
Eric M.
System Analyst
“Liked extracting email data and attachments and the Upsert component for simpler loads. Found the Excel tools lack xls support and wanted more demo use cases.”
Steven M.
Director of Technology
“Liked the broad data access, minimal training needed, and good value. Found some controls missing on older SQL Server versions and some components slow.”
Shane C.
Data Engineer
“Liked the time saved on migrations and useful tasks beyond Upsert. Found that testing environments require purchasing a second license.”
Beth F.
Director of Business Intelligence
“Liked that non-coders can work with REST APIs and the strong connectors. Found REST error handling in need of work and wanted a Google Analytics connector.”
Jason S.
BI Developer/Architect
“Liked the significant time saved compared with built-in or script tasks. Found the documentation sparse, with few real-world examples to follow.”
Michael C.
Lead BI Analyst/Lead Data Architect
“Liked automating Salesforce loads and Secure FTP working well after a patch. Found some Oracle data type issues, though mostly caused by SSIS itself.”
Edwin D.
SQL Server Engineer
“Liked how it handles tasks beyond standard Microsoft transforms. Found account management in the customer portal made adding users slow.”
John R.
DBA
“Liked the integration with Visual Studio and stable Salesforce components. Found that not all SOQL query syntax is supported by the connector.”
Raghav K.
Software Engineer
“Liked the easy Salesforce connectors and useful Upsert destination. Found troubleshooting and logging detail limited and wanted more information when errors occur.”
Zuzana H.
SQL Developer
“Liked the wide range of components, flexible configuration, and active community. Found the learning curve steep and wanted training included with the product.”
SSIS application connectors
Large SSIS connector library for business apps
SSIS task extensions
Broad set of SSIS tasks and components
SSIS data source connectors
Standard connectors for hundreds of data sources
SSIS REST and cloud
Strong REST, JSON, and cloud storage components