SSIS

SSIS

Customer Verified
About TrustRadius Scoring
Score 8.2 out of 100
SQL Server Integration Services

Overview

Recent Reviews

Worth of money

10 out of 10
June 23, 2022
As a BI / Data Analyst, I have to deal with multiple data source integrations independent of to live environment. So, I have to combine …
Continue reading
Read all 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.8
    88%
  • Connect to traditional data sources (57)
    8.7
    87%
  • Complex transformations (56)
    7.8
    78%
  • Testing and debugging (52)
    6.9
    69%

Reviewer Pros & Cons

View all pros & cons

Video 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 pricing
N/A
Unavailable

What is SSIS?

Microsoft's SQL Server Integration Services (SSIS) is a data integration solution.

Entry-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

What is Fivetran?

Fivetran replicates applications, databases, events and files into a high-performance data warehouse, after a five minute setup. The vendor says their standardized cloud pipelines are fully managed and zero-maintenance. The vendor says Fivetran began with a realization: For modern companies using…

N/A
Unavailable
What is SolarWinds Task Factory?

According to the vendor, SolarWinds Task Factory saves time managing tedious ELT/ETL tasks with high-performing SQL Server Integration Services (SSIS) components that can be used within the Visual Studio environment to connect to nearly any data source. Task Factory’s components and tasks have been…

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 SystemsUnspecified
Mobile ApplicationNo

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 alternatives

Reviews and Ratings

 (257)

Ratings

Reviews

(1-25 of 48)
Companies can't remove reviews or game the system. Here's why
Jonathan Leong | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
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.
Alex Bransky | TrustRadius Reviewer
Score 5 out of 10
Vetted Review
Verified User
Review Source
Fivetran, Stitch, and Etleap are all 1000x more modern than SSIS and 100x less aggravating. While those tools are mainly used to sync data rather than transform it, the ELT model works much better than the ETL model in most situations.
Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
Abhinav Choudhary | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
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.
Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
Score 6 out of 10
Vetted Review
Verified User
Review Source
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.
Score 9 out of 10
Vetted Review
Verified User
Review Source
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.
Vishal Shah | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
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).
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
Chris Guru | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
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.
Score 6 out of 10
Vetted Review
Verified User
Review Source
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.
Vladimir Salnikov | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
February 17, 2020

SSIS Just Works

Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
zahit bogus | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
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

Score 9 out of 10
Vetted Review
Verified User
Review Source
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.
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
Steven Gockley, MBA, MCSA | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
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.
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
Score 8 out of 10
Vetted Review
Verified User
Review 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.
Score 8 out of 10
Vetted Review
Verified User
Review Source
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.