Skip to main content
TrustRadius
SSIS

SSIS

Overview

What is SSIS?

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

Read more
Recent Reviews

Worth of money

10 out of 10
June 23, 2022
Incentivized
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 11 features
  • Connect to traditional data sources (53)
    8.8
    88%
  • Simple transformations (53)
    8.5
    85%
  • Complex transformations (52)
    7.7
    77%
  • Testing and debugging (48)
    6.1
    61%
Return to navigation

Pricing

View all pricing
SSIS

SSIS

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?

26 people also want pricing

Alternatives Pricing

Clear Analytics

Clear Analytics

$29
Per Seat per Month
What is Clear Analytics?

Clear Analytics is a business intelligence solution that enables non technical end users to perform analytics by leveraging existing knowledge of Excel coupled with a built in query builder. Some key features include: Dynamic Data Refresh, Data Share and In-Excel Collaboration.

Vertify

Vertify

$7,350
per year
What is Vertify?

VertifyData is a cloud-based integration platform with core integration capacities, including a drag-and-drop interface and real-time synchronization. It also offers over 80 prebuilt connectors and templates, plus customizable integrations for scaling businesses.

Return to navigation

Product Demos

Demonstration of Multicast transformation in SQL Server Integration Services (SSIS)

YouTube

SSIS Tutorial Part 78- What is Multicast Transformation in SSIS (Quick Demo)

YouTube

SSIS Tutorial Part 119-Execute SQL Task (Full Result Set) Demo in SSIS Package

YouTube

SSIS Tutorial Part 72- What is Conditional Split Transformation in SSIS (Quick Demo)

YouTube

SSIS Tutorial Part 02- How to Load Tab Delimited File To SQL Server Table in SSIS Package

YouTube
Return to navigation

Features

Data Source Connection

Ability to connect to multiple data sources

7.5
Avg 8.2

Data Transformations

Data transformations include calculations, search and replace, data normalization and data parsing

8.1
Avg 8.4

Data Modeling

A data model is a diagram or flowchart that illustrates the relationships between data

7.4
Avg 8.1

Data Governance

Data governance is the practise of implementing policies defining effective use of an organization's data assets

6.9
Avg 8.2
Return to navigation

Product Details

What is SSIS?

SSIS Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

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

Reviewers rate Connect to traditional data sources highest, with a score of 8.8.

The most common users of SSIS are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(259)

Attribute Ratings

Reviews

(1-25 of 53)
Companies can't remove reviews or game the system. Here's why
June 29, 2022

SSIS had its day, but in the big leagues it can no longer play

Alex Bransky | TrustRadius Reviewer
Alex Bransky
Principal Data Engineer
Ad Hoc LLC (Information Technology & Services, 201-500 employees)
Score 5 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
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.
June 28, 2022

SSIS, the must have extension for SSMS

Verified User
Analyst in Corporate
Utilities Company, 1001-5000 employees
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
  • 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
June 25, 2022

Rapid and low cost integration with various sources for a DW

Verified User
Professional in Information Technology
Leisure, Travel & Tourism Company, 201-500 employees
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
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).
June 25, 2022

One of the best on-premise ETL tools

Verified User
Manager in Information Technology
Design Company, 5001-10,000 employees
Score 6 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
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.
June 24, 2022

Amazing data warehousing tool

Robbie Scott | TrustRadius Reviewer
Robbie Scott
Security Software Engineer
Tata Consultancy Services (Information Technology & Services, 10,001+ employees)
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
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.
June 24, 2022

Good for startups or companies with limited data variability, Big data companies will need better tools

Vishal Shah | TrustRadius Reviewer
Vishal Shah
Data Engineer, Product Analytics
Carvana (Automotive, 5001-10,000 employees)
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
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.
June 24, 2022

Data integration and migration are made easier with this tool.

Shubham Rawat | TrustRadius Reviewer
Shubham Rawat
Data Analyst
DayToDay Health (Hospital & Health Care, 201-500 employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
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.
June 24, 2022

Trust Microsoft to vanish your data integration troubles

Verified User
Analyst in Sales
Logistics & Supply Chain Company, 10,001+ employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
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.
June 23, 2022

SQL Server Integration Services (SSIS) is a winner and helps solve many business problems effectively.

Verified User
Director in Sales
Management Consulting Company, 5001-10,000 employees
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
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

Verified User
Analyst in Information Technology
Information Technology & Services Company, 201-500 employees
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
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.
June 23, 2022

Data processing with SSIS

John Ramírez | TrustRadius Reviewer
John Ramírez
Database Developer
Experian (Information Technology & Services, 1001-5000 employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
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
June 23, 2022

SSIS, free but not intuitive

SF
Sean Ford
Database Engineer
Shelter Insurance (Insurance, 1001-5000 employees)
Score 6 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
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.
May 01, 2021

SQL Server Express + SSIS basics

Vladimir Salnikov | TrustRadius Reviewer
Vladimir Salnikov
Hardware / Embedded Software (C/C++) Developer
Waldorf Music GmbH (Information Technology & Services, 11-50 employees)
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
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.
April 30, 2021

SQL Server Integration Services proves to be a valuable tool.

Verified User
Administrator in Information Technology
Education Management Company, 1001-5000 employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
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

JS
John Stuchly
Data Developer
HKS Inc (Architecture & Planning, 1001-5000 employees)
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
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.
January 19, 2020

Great Tool For ETL Design

zahit bogus | TrustRadius Reviewer
zahit bogus
Business Intelligence Consultant
EMO A.Ş (Information Technology & Services, 501-1000 employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
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

Verified User
General Manager in Information Technology
Non-Profit Organization Management Company, 11-50 employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
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.
October 13, 2019

SSIS enables you to build the data lake of your dreams!

Verified User
Supervisor in Information Technology
Chemicals Company, 51-200 employees
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
SSIS is well-suited for scheduled data loads, such as scraping web pages for currency rates or storm-related delivery delays and writing the results to an application database or copying transactional data from a source system, optimizing it for reporting, and writing to a reporting server. SSIS is also great in helping to combine data from disparate sources to build a deeper data analysis platform.
July 30, 2019

SQL Server Integration Services, worth a look

Steven Gockley, MBA, MCSA | TrustRadius Reviewer
Steven Gockley, MBA, MCSA
DBA / Sr. Data Analyst
Boostability (Marketing and Advertising, 201-500 employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
If you are a SQL Server shop, it is almost not even a question. The tool slides in nicely and is fairly easy to get going and implement. I have used it for Data Warehousing, Report Automation, DBA Task Automation, System Integrations and even Web Testing. It is extremely flexible and anyone working heavily with SQL Server should really look at using it.
July 18, 2019

Data integration for everyone. A powerful tool that anyone can master.

Verified User
Project Manager in Information Technology
Computer Software Company, 201-500 employees
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
  • SSIS is particularly well suited for jobs that need to be consistent, repeatable, and error managed.
  • Ongoing extract, transform, load [ETL] jobs that are scheduled or manual.
  • One-time ETL with complex datasets.
  • Migrations of large datasets.

SSIS is not well suited for small or simple datasets that can be copied or exported safely to flat files for import. It is possible to do this but would generally take longer to build in SSIS unless there was a good reason to .remove manual handling of the data in transport or the action needed to be testable/repeatable.
July 07, 2019

In the world of IT this should be a standard tool, at least in any Windows environment

Verified User
Technician in Information Technology
Medical Devices Company, 201-500 employees
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Any integration tasks in a Windows environment like AD or application integration, DB integration, etc. The drag and drop workflow and easy language, for example, derived data changes are so easy to make that it reminds of Excel functions. Full flexibility to draw up any workflow and easy troubleshooting using the data viewer.
Return to navigation