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 57)
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 highly recommend this product. It has streamlined most business processes by providing useful tools that make work easier. The well-featured dashboard provides graphical integration services that have enhanced faster task and project implementation since it does not require coding. It has transformed data that could lead to poor performance into useful insights for generating new ideas for boosting business performance.
Alex Bransky | TrustRadius Reviewer
Score 5 out of 10
Vetted Review
Verified User
Review Source
If you already have licenses for SQL Server and need to get data from A to B, especially if A and/or B is SQL Server, then SSIS could be a reasonable choice, especially if you can't use a cloud tool like Fivetran due to security concerns.
Score 8 out of 10
Vetted Review
Verified User
Review Source
  • SSIS is an in-memory pipeline. That’s why it’s important to make sure that all transformations occur in memory
  • Try to minimize logged operations
  • Plan for capacity by understanding resource utilization
  • Optimize the SQL lookup transformation, data source, and destination
  • Schedule and distribute it correctly
Abhinav Choudhary | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
We use it majorly for data migration to other DB that we have internally and Data mining and export of data as we require it for various analyses. If your data is not wrangled correctly it becomes a big task to rectify and then use the SQL Server Integration Services wizard for data extraction.
Score 8 out of 10
Vetted Review
Verified User
Review Source
I do not think that SQL Server Integration Services (SSIS) is great for complex dependency management and scheduling for an entire DW load. However, it is great for smaller units of work and particularly where moving data between systems is required due to its extensive and extensible connectivity options. That said, it is obviously focused on traditional on-premise systems and cloud-based environments are likely to prefer using the next-generation version of SSIS being Azure Data Factory (ADF).
Score 6 out of 10
Vetted Review
Verified User
Review Source
SQL Server Integration Services is well suited for anyone beginning to learn ETL. It's a great tool, to understand the nuances of setting data integrations and transformations. SQL Server Integration Services is not meant for ELT or ETLTL operations, natively. The workaround would be to have multiple packages/pipelines where one package performs the EL and the other package performs the T.
Robbie Scott | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
We have used SSIS to perform extensive data migration tasks from various sources like DB2 databases, SQL server databases... It works speedily making it easy for us to move data from one database to the other. It also has a GUI that helps us extract, transform, and clean data easily without writing code. It works well except for the error messages.
Score 9 out of 10
Vetted Review
Verified User
Review Source
There are always alternative options available to meet the demand for integration. In my opinion, SQL Server Integration Services has a wide variety of capabilities that makes it a very versatile tool for developing dependable integration strategies. When determining which tools to utilize, vendor interfaces may play a significant role, and technologies like PowerShell have been used by colleagues to aid in this decision. For even more user-friendliness, our SSIS solution additionally makes use of a third-party plugin.
Vishal Shah | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
Ideal for daily standard ETL use cases whether the data is sourced from / transferred to the native connectors (like SQL Server) or FTP. Best if the company uses MS suite of tools. There are better options in the market for chaining tasks where you want a custom flow of executions depending on the outcome of each process or if you want advanced functionality like API connections, etc.
Shubham Rawat | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
1. Combining and integrating data from a variety of sources.
2.There is no additional necessity to learn anything other than SQL.
3. Assists in the analysis of client data by bringing it all together in one place.
4. Data leaks of clients' personal information are avoided. It is HIPAA compliant and it has very secure server.
Score 9 out of 10
Vetted Review
Verified User
Review Source
The service is very well suited if you want to integrate various data sources spread across the cloud & compile all that data in one place effectively & quickly. The service can use a little work in connecting to multiple data sources over the cloud at one go & struggles if too many data connections are used together.
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
June 23, 2022

Worth of money

Score 10 out of 10
Vetted Review
Verified User
Review Source
While integrating Google Ads FB ads and maintaining the cost analysis. it was quite easy and very smooth with PowerBI. I always use powerBI for Data Analysis reporting and SSIS is a very smooth experience to use large databases.
Chris Guru | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
SQL Server, It's the tool for querying and it's better to go and create stored procedures, table/objects, or query any table from any database. The User Interface It provides is really good and easy to get started. In SSIS we can query create logics and export the result into such as CSV for data analysis. It serves a great purpose for the data migrations projects. And there is room for improvements in its automation capabilities were something we are doing manually such as we have to load CSV files one by one and not in one go.
John Ramírez | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
Automation for data transfer, where you don't need to be moving or copying any data manually.
Processing data, for ETL, so you can just get the files, using something like FTPs automation and the data will be processed, and then you can just work on your reports or do all the BI needed for the company
Score 6 out of 10
Vetted Review
Verified User
Review Source
I'd give it a 6 because it's very useful functionality that isn't available elsewhere. My preference would be to use python or some other scripting to do the same thing where it makes sense to me, instead of how it forces you to think in a specific way.

GUI is nice and it's very cool to see your project actually running in real time.
Vladimir Salnikov | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
Well suited: all data extraction from file (spreadsheet-like) and RDBMS data sources, mix up them into one integrated meta-data source for future processing.
Less appropriate: big key-value data storages processed slowly, and hard to make data mining through uniting non-RDBMS and RDBMS data sources naive way. The data from non-SQL databases should be prepared accordingly to be represented in a table-like way if possible.
Score 9 out of 10
Vetted Review
Verified User
Review Source
There are certainly always other ways to provide integration as needed. I find SQL Server Integration Services very flexible and broad in the range of things needed to provide a robust integration solution. Vendor interfaces are possibly a key area in deciding what tools to use, and coworkers have used tools like PowerShell to help. We also use another Vendor add-on to help our SSIS implementation to ease use.
February 17, 2020

SSIS Just Works

Score 8 out of 10
Vetted Review
Verified User
Review Source
SSIS works great for 80+ percent of ETL use cases. It is particularly well suited for migrating and transforming data between traditional databases. If using the Azure cloud, it also has a number of built-in components to make that process easier. The base set of transforms are pretty robust and will perform most tasks with decent speed.
zahit bogus | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
For enterprise business intelligence projects, the SQL Server Integration Services ETL tool is a logical choice to move your data to the data warehouse on a daily basis. The SSIS ETL tool has enough functions and capabilities to design the data warehouse. If you want to send your JSON data to the database, SSIS does not work here.
November 24, 2019

Our use of SSIS

Score 9 out of 10
Vetted Review
Verified User
Review Source
Well suited and designed to enable flexible data extract and transformation to and from an SQL server. It works very well for repetitive tasks and it is easy to manage (and change) packages once built. The use of templates makes the initial startup process simpler.

SQL Server Integration Services (SSIS) is not easy for new users due to the plethora of options available.