SSIS
SQL Server Integration Services
Overview
Recent Reviews
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Popular Features
View all 12 features- Simple transformations (57)8.888%
- Connect to traditional data sources (57)8.787%
- Complex transformations (56)7.878%
- Testing and debugging (52)6.969%
Reviewer Pros & Cons
View all pros & consVideo Reviews
Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of SSIS, and make your voice heard!
Pricing
View all pricingEntry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting / Integration Services
Would you like us to let the vendor know that you want pricing?
8 people want pricing too
Alternatives Pricing
Features Scorecard
Data Source Connection
7.6
76%
Data Transformations
8.3
83%
Data Modeling
7.8
78%
Data Governance
7.4
74%
Product Details
What is SSIS?
Microsoft's SQL Server Integration Services (SSIS) is a data integration solution.
SSIS Technical Details
Operating Systems | Unspecified |
---|---|
Mobile Application | No |
Frequently Asked Questions
Microsoft's SQL Server Integration Services (SSIS) is a data integration solution.
Reviewers rate Simple transformations highest, with a score of 8.8.
The most common users of SSIS are from Enterprises (1,001+ employees) and the Information Technology & Services industry.
Comparisons
View all alternativesCompare with
Reviews and Ratings
(257)
Reviews
(1-25 of 48)- Popular Filters
Companies can't remove reviews or game the system. Here's why
I have gained the best experience from the operation of this product. I have not worked with advanced platforms in the data transformation category like SQL Server Integration Services. It has all modern data management models and programming tools that have enhanced my team to develop suitable business suites. The cost of running this model is relatively low compared to most business data management tools in the market. It purifies data before we integrate it into our business application for positive results.
June 28, 2022
SSIS, the must have extension for SSMS
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.
June 25, 2022
Data Solutions at its Best!!
The only reason for choosing SQL Server Integration Services was the simple usage without many complications, Its easily accepted by Users, Gives us the complete flexibility migrate data and choose its format. Google products have a high cost and are prone to down times as we have observed. SQL Server Integration Services was suiting our business purpose both internally and externally.
Low-cost relative to other products - in fact, zero cost if one is considering the license cost as being for the database engine with Integration Services added on. It has a comparable range of functionality and performance and as such it's a 'no-brainer' to use SSIS over other data integration tools.
June 25, 2022
One of the best on-premise ETL tools
SnapLogic and Azure Data Factory are better than SQL Server Integration Services mostly because they are Integration Platform as a Service (IPAAS) services, whereas SQL Server Integration Services is an on-premise. So the basic differences such as, need a VPN to connect to the data sources from SQL Server Integration Services, or upgrades are not seamless compared to IPAAS come into play.
June 24, 2022
Amazing data warehousing tool
One of the most popular alternatives to Microsoft's SQL Server Integration Services is Microsoft Power BI, although getting up and running with it is more difficult and costly than with SQL Server Integration Services. If more complex data transformation and loading (DTS) is needed later on, upgrading to the paid Standard Edition of SQL Server Integration Services is a straightforward process. Additionally, the MS community and MSDN technical resources provide a wealth of information to help get you up and running quickly. Further, in contrast to the costly SAP prerequisites, the installation/administration steps are straightforward and extensively documented.
June 24, 2022
Good for startups or companies with limited data variability, Big data companies will need better tools
SSIS is similar to Alteryx and Informatica PowerCenter in a way because these are all drag-and-drop ETL tools with similar functionality. Alteryx is a step ahead because it has some advanced ETL functionalities including statistical calculations etc. and a better ability to set process dependencies. Informatica is by far the most powerful ETL tool I've used but it can be daunting for a new user because it has so many options and configurations, SSIS does similar work with less complexity (it is easier to use).
It is more user-friendly and cost efficient.
June 23, 2022
SQL Server Integration Services (SSIS) is a winner and helps solve many business problems effectively.
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.
June 23, 2022
SQL Server Integration Services Review
Not used any other integration applications other than SQL Server Integration service's yet but for me, in most areas SSIS stands out for the business needs and meets its objectives definitely few things can be improved such as most of the automation, conversion, timing of ETL on data Migration, etc.
June 23, 2022
SSIS, free but not intuitive
I had nothing to do with the choice or install. I assume it was made because it's easy to integrate with our SQL Server environment and free. I'm not sure of any other enterprise level solution that would solve this problem, but I would likely have approached it with traditional scripting. Comparably free, but my own familiarity with trad scripts would be my final deciding factor. Perhaps with some further training on SSIS I would have a different answer.
December 08, 2021
Provides value to cost and excellent with MSBI Stack, But needs more features/updates
SQL Server Integration Services is a good alternative to cut down on costs and have more flexibility on developing.
May 01, 2021
SQL Server Express + SSIS basics
SAP Business Objects was a primary concurrent software against the MS SSIS but it has a more steep learning curve and requires additional investment into the SAP-related software infrastructure. With SSIS one can start easily with simple data extraction / DTL tools of Express Edition (which is free) and then migrate to the Standard Edition if any advanced DTS will be required. Also, the MS community and MSDN tech resources contain a lot of useful info to allow a quick start. Also, installation/administration processes are easy and well-documented counter to expensive SAP requirements. One can start with totally free solutions and scale them in the future. As an example - you can use a free Hyper-V core server on a very cheap 1000-1500 USD Dell/HPE entry-level server, then virtualize one instance of Win10 Pro, and inside this virtual machine install the SQL Server Express with SSIS (as Data Transformation and Import / Export wizard). With a certain amount of imagination, this could be a very good start point to unite a moderate amount of data, collected in the small organization for decades.
Datastage
February 17, 2020
SSIS Just Works
I personally prefer SSIS. There are items that each do better than the others, but the ease of use of SSIS, along with its extensibility to 3rd party, ability to write any code required in the tool, and uses the same IDE for the MS BI suite (more of an issue if you're not a pure ETL developer) place it ahead of Informatica and Ab Initio. I would give credit to Ab Initio for having the overall most approachable interface despite being a niche tool.
January 19, 2020
Great Tool For ETL Design
I used the Pentaho Data Integration (PDI) ETL tool. The PDI ETL tool does not have a public user collection like the SQL Server Integration Services(SSIS) ETL tool. Therefore, you may not be able to find instant solutions for your problems. But it has advantages over the SSIS ETL tool. The PDI ETL tool is open source software and does not charge a license fee.
November 24, 2019
Our use of SSIS
We selected SSIS as it came part of our standard SQL license. We did not evaluate any other solutions as SSIS has met all our needs.
October 13, 2019
SSIS enables you to build the data lake of your dreams!
SQL Server is already in our wheelhouse so it only made sense to utilize the tools we already had available to us--SSIS, SSAS, & SSRS. Other non-technical users seem to be more comfortable using alternatives to SSIS. However, these alternatives are not as good as SSIS at building production-ready ETL processes.
July 30, 2019
SQL Server Integration Services, worth a look
These are all great products and, honestly, can move data faster. They include more enterprise features and have some great qualities about each. However, they all cost a lot depending on the implementation you need. With SQL Server Integration Services, you do not have any added cost and, for most cases, it is more than enough of a tool. If you are a shop that has specific needs and budget other tools will certainly be worth a look but, I would always try with SSIS first. It really is a great tool.
When looking to evaluate different options, we looked first to the experience and software we had in-house that would accomplish the job. When assessing alternatives outside we were looking for the tool that would offer the most flexibility.
SSIS provided the most robust set of features with the smallest learning curve out of its major competitors and was the lowest cost to implement.
SSIS provided the most robust set of features with the smallest learning curve out of its major competitors and was the lowest cost to implement.
It’s basically a free tool and it has more features than anyone would ever need. If you look online for answers for SISS packages you will find a world of information that can cover almost any situation for your business. This tool can be used in any business and it provides the flexibility to integrate into any system or database or data source.
SSIS is a very basic, developer-oriented ETL tool and while it lacks many of the nice UX features of its competitors it is a powerful tool that comes as a part of SQL Server and, in the hands of experienced developers with domain knowledge, can meet most organizations' ETL needs without the need to purchase and maintain additional software packages in developer and production environments.
June 07, 2019
SSIS - Strong performer in the traditional data space, but can be improved in handling JSON objects
SSIS and Denodo differ in their approaches to ETL and Data integrations. SSIS is more affordable from a cost and licensing perspective (if you have Microsoft licensing), but Denodo is no slouch. If you go with Denodo, you are not creating data, there are pros and cons to that. With SSIS, lots of times you are persisting information in order to perform ETL. Again, there are pros and cons to this, but both require proper implementation and data architecture.