SSIS | SQL Server Integration Services | Compare to other ETL
Passionned Group is a leading analyst and consultancy firm specialized in Business Analytics and Business Intelligence. Our passionate advisors assist many organizations in selecting the best Business Analytics Software and applications. Every two years we organize the election of the smartest company.

Microsoft ETL solution

SQL Server Integration Services (SSIS) connect and transform disparate data sources. Gain a scalable enterprise data integration platform with exceptional extract, transform, and load (ETL) and integration capabilities by using Microsoft SQL Server Integration Services.

other ETL tools

Which features does SQL Server Integration Services (SSIS) support?

If you want to know how SQL Server Integration Services (SSIS) scores on different ETL evaluation criteria and exactly which functionality it provides. We did all the work for you. Vendors will often tell you only the strengths of their product(s). In our vendor neutral survey, all the features are revealed, including the weak points. Why buy our 100% vendor independent survey?

Information from the vendor

Many believed that Microsoft would take the lead in the BI marketplace

Many of the ETL vendors were apprehensive that Microsoft would take the lead in both the BI and the ETL marketplaces. This is not so surprising, given Microsoft’s clout in the software market, but it doesn’t seem to be happening. Microsoft’s strategy appears to be to take their time developing a good product, often inspired by products from other ETL vendors, and then give it away. It took five years to develop Integration Services and it is completely different from its predecessor Data Transformation Services (DTS), a product that was never very highly rated.

SSIS contains valuable features

Integration Services contains valuable features for slowly changing dimensions (not just a wizard, it is out-of-the-box), debugging (it is integrated in the Visual Studio suite), pivoting, union, reusability and more. The usability when compared to other tools is quite high, but it only runs on the Windows platform and then integrated with the database SQL Server. In this environment, the product performance is excellent, having nearly all the features an ETL developer needs. It lacks however some of the more sophisticated functions and features available in other products. The What You See Is What You Get feature is very well implemented. Integration Services however misses real-time facilities and does not provide functions for data quality inspection and improvement and has limited facilities for changed data capture.

Key Capabilities

  • Write script tasks with Microsoft Visual C# and Microsoft Visual Basic .NET.
  • Work with the ADO.NET for source and destination components.
  • Use thread pooling and enhanced lookup transformations.
  • Take advantage of the improved Import and Export Wizard.

Creating process flow for data through your organization can be one of the most challenging tasks. SQL Server Integration Services (SSIS) helps you with a robust enterprise-class data integration application.

Source: microsoft.com.

“Low price and ease of use”

Rick van der Linden, senior analyst and author of the ETL Tools & Data Integration Survey said about SQL Server Integration Services (SSIS): “The only disadvantage being the lack of support for “unusual” types of files and application packages, this may well be compensated by the low price and ease of use.” Find out more and order now the ETL Tools & Data Integration Survey 2018.

100% vendor independent research

In the ETL Tools & Data Integration Survey 2018 you’ll find the list of ETL tools in the market, including for each ETL platform an expert review, many comparison graphs and a comparison matrix with all the features. And a thorough 100% vendor independent evaluation of SQL Server Integration Services (SSIS) and all the major ETL solutions.

to the etl tools survey

A selection of our customers

Become a customer with us now

Do you also want to become a customer of ours? We are happy to help you with ssis (sql server integration services) or other things that will make you smarter.

Daan van Beek, Managing Director

DAAN VAN BEEK MSc

Managing Director

contact me directly

Fact sheet

Number of organizations serviced
144
Number of training courses
145
Number of participants trained
146
Overall customer rating
8.9
Number of consultants & teachers
147
Number of offices
3
Number of years active
14