SSIS, the must have extension for SSMS
June 28, 2022
SSIS, the must have extension for SSMS
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with SQL Server Integration Services
SQL Server Integration Service (SSIS) is a component of the Microsoft SQL Server database software that we use to execute a wide range of data migration tasks. SSIS is a fast & flexible data warehousing tool used for data extraction, loading, and transformation like cleaning, aggregating, merging data, etc. It makes it easy to move data from one database to another database. SSIS can extract data from a wide variety of sources like SQL Server databases, Excel files, Oracle and DB2 databases, etc.
- Offers real-time, message-based capabilities
- Tight integration with SQL Server and visual studio
- Ease and speed of implementation
- Standardized data integration
- Sometimes create issues in non-windows environments.
- SSIS lacks support for alternative data integration styles.
- Problematic integration with other products.
- Reduce data migration task to half of time.
- Additional investment to integrate with other company tools.
We just selected SSIS because we use SQL Server Management System (SSMS) to manage our database. As SSIS is a component of the Microsoft SQL Server there are no problems with integration and everything works perfectly. In addition, we don't have to learn how to use another system to perform database tasks and everything is done in the same place. Just like it was an extension of our SSMS.
Do you think SQL Server Integration Services delivers good value for the price?
Yes
Are you happy with SQL Server Integration Services's feature set?
Yes
Did SQL Server Integration Services live up to sales and marketing promises?
I wasn't involved with the selection/purchase process
Did implementation of SQL Server Integration Services go as expected?
Yes
Would you buy SQL Server Integration Services again?
Yes