SQL Server Integration Services (SSIS) is a winner and helps solve many business problems effectively.
June 23, 2022

SQL Server Integration Services (SSIS) is a winner and helps solve many business problems effectively.

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

Overall Satisfaction with SQL Server Integration Services

We used Integration Services to extract and transform data from a wide variety of sources such as XML data files, flat files, and relational data sources, and then load the data into one or more destinations. We also used the graphical Integration Services tools to create business solutions for the firm.
  • Create Packages in SQL Server Data Tools
  • Reuse Control Flow across Packages by Using Control Flow Package Parts
  • Build Integration Services User Interface
  • We can improve Integration Services error messages, including a list of most Integration Services errors and their description.
  • Improvement to create custom event handlers for these events to extend package functionality.
  • Better support for tools and wizards helping with Legacy Package Deployment.
  • Faster loading of new data (imports).
  • Very effective data cleansing or transformation of dirty data.
  • Managing critical DBA tasks like purging old files or indexing a database.
Alteryx Designer is easier to use for machine learning models. The functionality of drag and drop is the most valuable. It is a very user-friendly tool that can be understood easily. My teams also work with other solutions, such as Integration Services, and these solutions are very difficult for people who don't have technical knowledge.

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

Integration Services is very helpful to solve complex business problems by copying or downloading files, loading data warehouses, cleaning and mining data, and managing SQL Server objects and data. It provides Graphical tools for building packages. Also, it helps with the SSIS Catalog database to store, run, and manage packages for business solutions.

SSIS Feature Ratings

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