Item: SQL Server Integration Services
Rating: 10
Author: Verified User

Overall Satisfaction with SQL Server Integration Services

Use Cases and Deployment Scope

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.

Pros and Cons

Pros

Create Packages in SQL Server Data Tools
Reuse Control Flow across Packages by Using Control Flow Package Parts
Build Integration Services User Interface

Cons

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.

Return on Investment

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.

Alternatives Considered

Alteryx

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.

Key Insights

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

Other Software Used

Alteryx, Tableau CRM, Python IDLE

Likelihood to Recommend

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

Comments

Please log in to join the conversation

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