SSIS, the must have extension for SSMS
June 28, 2022

SSIS, the must have extension for SSMS

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

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

  • SSIS is an in-memory pipeline. That’s why it’s important to make sure that all transformations occur in memory
  • Try to minimize logged operations
  • Plan for capacity by understanding resource utilization
  • Optimize the SQL lookup transformation, data source, and destination
  • Schedule and distribute it correctly

SSIS Feature Ratings

Connect to traditional data sources
9
Connecto to Big Data and NoSQL
5
Simple transformations
9
Complex transformations
7
Data model creation
9
Metadata management
8
Business rules and workflow
8
Collaboration
5
Testing and debugging
Not Rated
feature 1
Not Rated
Integration with data quality tools
Not Rated
Integration with MDM tools
3