SSIS is the #3 ranked solution in
top Data Integration Tools. PeerSpot users give SSIS an average rating of 7.6 out of 10.
SSIS is most commonly compared to Informatica PowerCenter:
SSIS vs Informatica PowerCenter. SSIS is popular among the large enterprise segment,
accounting for 70% of users researching this solution on PeerSpot. The top industry researching this solution are professionals from a
financial services firm, accounting for 16% of all views.
SSIS Buyer's Guide
Download the SSIS Buyer's Guide including reviews and more. Updated: January 2023
What is SSIS?
SQL Server Integration Services (SSIS) is a Microsoft platform designed to build enterprise-level data integration and data transformation solutions. Users now have the ability to solve intricate business queries by downloading and copying files, cleansing and mining data, loading data warehouses, and managing SQL Server objects and data through Integration Services. SSIS is a component of the Microsoft SQL Server data software used for many data migration tasks.
SSIS loads data into one or more destinations by extracting and transforming data from a wide variety of sources such as XML data files, flat files, and relational data sources.
Integration Services include:
- An SSIS catalog database to manage, store, and run packages.
- An ample set of built-in transformations and tasks.
- Graphical tools for building packages.
Create packages programmatically and code custom tasks through programming the extensive Integration Services. With graphical Integration Services, you can create solutions without writing any code.
Benefits of SSIS
There are many benefits of SSIS, such as:
-
Solve complex business problems - encrypt files with SSIS and send them to various network locations.
-
Migration of DTS packages to SSIS - users can migrate DTS packages to SSIS while choosing to run DTS packages using DTS runtime or incorporate DTS packages into SSIS.
-
Development of ETL processes - Microsoft’s SSIS packages provide the ability to extract, transform, and load data into data warehouses. This service takes data from various sources, like CSV files, XML files, flat files, and relational data sources and transforms and loads them to their destinations.
-
Data migration from other databases - with Integrations Services, users can transform data to make sure it complies with the rules of the database they are migrating to.
-
Managing and automating SQL server objects - SSIS packages can manage and automate SQL server objects which will help save you time and resources.
Reviews from Real Users
The SSIS platform stands out among its competitors for a variety of reasons. Two major ones are its debugging capabilities during data flow execution and its easy connectivity with other Microsoft tools.
Muhammad J., a senior manager software developer at Techlogix, notes, "The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
Ismail L., a data engineer at a tech service company, writes, "The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."
SSIS was previously known as SQL Server Integration Services.
SSIS Customers
PKP Energetyka, UniCredit Bank, Mostar, waldwasser, Ashok leyland, Florida Atlantic University, Stadt Frankfurt am Main
SSIS Video
The insight into running packages comes from the BiXpress Audit and Notification frameworks which are an extra cost per developer. But it's invaluable. And I would argue it gives you insight into what's running like no other tool on the market can. Its as if you were running a debugger in production as you can watch data values change in variables as it runs and data counts as the data flows run. And it handles all the error handling for you which is massive. It sends you formatted and informative email or text when something dies with where it died and why. There is some performance cost but you can turn off SSIS logging so its basically swapping logging methods and BiXpress is SO far superior to the built in logging of SSIS.