Amazing data warehousing tool
June 24, 2022

Amazing data warehousing tool

Robbie Scott | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with SQL Server Integration Services

We are currently using SQL Server as our central relational database. Getting data from multiple sources to our data depository is smooth. We use SQL Server Integration Services to copy and download large files as well as to draw out and modify data from several sources of data like XML data files, DB2 databases, and relational data sources and then load the data into a single destination.
  • I am able to use the GIS tools to easily generate solutions without coding.
  • Built in tasks that speed up web developing.
  • SSIS enables automated data preparations.
  • Amazing integration with Microsoft tools.
  • Creation of ETL mapping.
  • It depends so much on the Microsoft environment and has integration issues with other formats like JSON and Excel.
  • Error messages are unclear, this makes us spend a lot of time figuring out what has gone wrong making the debugging process hectic.
  • We can easily merge data on a variety of databases.
  • Loading and migrating data is fast.
  • It offers a simple system for analyzing raw data.

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?


Azure Virtual WAN, Azure Bot Service (Microsoft Bot Framework)
We have used SSIS to perform extensive data migration tasks from various sources like DB2 databases, SQL server databases... It works speedily making it easy for us to move data from one database to the other. It also has a GUI that helps us extract, transform, and clean data easily without writing code. It works well except for the error messages.

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
Testing and debugging
feature 1
Integration with data quality tools
Integration with MDM tools