One of the best on-premise ETL tools
June 25, 2022

One of the best on-premise ETL tools

Anonymous | TrustRadius Reviewer
Score 6 out of 10
Vetted Review
Verified User

Overall Satisfaction with SQL Server Integration Services

SSIS is an on-premise data transformation tool and the first major ETL tool we have used. We use it to ETL data from Workday, and other internal applications/databases to our internal databases. The product addresses the issue of getting data from CSV files from our SFTP and performing update/insert/delete operations on the data in our internal databases.
  • Connect to various sources
  • Basic transformations are included
  • Connect to various destinations
  • We still need plugins to connect to SFTP and other sources. Many vendors in the market give this by default
  • It's an ETL tool and the ability to do ELT or ETLTL means spinning up more pipelines and packages
  • It still has compatibility issues in Visual Studio 2017
  • Negative impact - We still need plugins like CozyRoc for basic things like connecting to SFTP. This slows development
  • Positive impact - We don't need to pay extra for this. It comes with SQL Server license.
SnapLogic and Azure Data Factory are better than SQL Server Integration Services mostly because they are Integration Platform as a Service (IPAAS) services, whereas SQL Server Integration Services is an on-premise. So the basic differences such as, need a VPN to connect to the data sources from SQL Server Integration Services, or upgrades are not seamless compared to IPAAS come into play.

Do you think SQL Server Integration Services delivers good value for the price?


Are you happy with SQL Server Integration Services's feature set?


Did SQL Server Integration Services live up to sales and marketing promises?


Did implementation of SQL Server Integration Services go as expected?


Would you buy SQL Server Integration Services again?


SQL Server Integration Services is well suited for anyone beginning to learn ETL. It's a great tool, to understand the nuances of setting data integrations and transformations. SQL Server Integration Services is not meant for ELT or ETLTL operations, natively. The workaround would be to have multiple packages/pipelines where one package performs the EL and the other package performs the T.

SSIS Feature Ratings

Connect to traditional data sources
Connecto to Big Data and NoSQL
Simple transformations
Complex transformations
Data model creation
Metadata management
Business rules and workflow
Not Rated
Testing and debugging
Integration with data quality tools
Integration with MDM tools