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

Learn from top reviewers

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

Rating: 5 out of 10
June 29, 2022
IncentivizedVetted ReviewVerified User
SSIS pulls data from various locations (mostly SQL Server instances but also some flat files and SFTP), mainly for transforming the data and putting it in the data warehouse.
Continue reading
Alex Bransky
Engineer - Engineering
Principal Data Engineer
Ad Hoc LLC
SQL Server Integration Services17 years of experience

Amazing data warehousing tool

Rating: 8 out of 10
June 24, 2022
IncentivizedVetted ReviewVerified User
We are currently using SQL Server as our central relational database. Getting data from multiple sources to our data depository is smooth. We use SQL Server Integration Servic...
Continue reading
Robbie Scott
Consultant - Information Technology
Security Software Engineer
Tata Consultancy Services
SQL Server Integration Services4 years of experience

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

Rating: 8 out of 10
June 24, 2022
IncentivizedVetted ReviewVerified User
SQL Server is the legacy Database and Data Warehouse in the company. SSIS is used for most ETLs where the data is sourced from / put into SQL Server, depending on the use case...
Continue reading
Vishal Shah
Engineer - Product Management
Data Engineer, Product Analytics
Carvana
SQL Server Integration Services3 years of experience

Data integration and migration are made easier with this tool.

Rating: 9 out of 10
June 24, 2022
IncentivizedVetted ReviewVerified User
A good tool for SQL server query and data migration. The way it stores data and makes it easier for the user to write queries over the server. Compatibility with different BI ...
Continue reading
Shubham Rawat
Employee - Research & Development
Data Analyst
DayToDay Health
SQL Server Integration Services2 years of experience

SSIS, free but not intuitive

Rating: 6 out of 10
June 23, 2022
IncentivizedVetted ReviewVerified User
SQL Server Integration Services is an extremely powerful tool that we're using exclusively for SQL Server inventory and other jobs. While it is very powerful, it's also not ex...
Continue reading
Sean Ford
Professional - Information Technology
Database Engineer
Shelter Insurance
SQL Server Integration Services3 years of experience
Log in with LinkedIn to see content from your network

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

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?

27 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.4

Data Transformations

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

8.1
Avg 8.2

Data Modeling

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

7.4
Avg 8.0

Data Governance

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

6.9
Avg 8.3
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 Mid-sized Companies (51-1,000 employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews From Top Reviewers

View all reviews
(1-5 of 9)

SSIS - A great ETL solution!

Rating: 9 out of 10
Incentivized
April 28, 2016
Verified User
Administrator in Information Technology
Financial Services Company, 501-1000 employees
Vetted Review
Verified User
SQL Server Integration Services
5 years of experience
Use Cases and Deployment Scope
SSIS is used by a lot of people within our technology department, but it is used heavily by our developers. We utilize this tool to move data between servers as an alternative to using a linked server and also to migrate data into our production systems from third party databases.
Pros
  • We use SSIS as a tool to help convert and migrate data from third party systems into our internally developed CRM system.
  • We use SSIS to move data from server to server, where a linked server is not present.
  • SSIS allows us to import tables directly from other sources (Access, Excel, etc.) to our Microsoft SQL environments.
  • SSIS is utilized to export data from our SQL servers into Access database backups for our clients who request backups of their data.
Cons
  • Although it's better than the old DTS, I think some more default integrated data sources/targets would be beneficial.
  • Integration with MySQL would be great. Currently we have to use Microsoft SQL Server Migration Assistant for MYSQL to get this done. If this was integrated into SSIS, it would alleviate the need for the other program.
Likelihood to Recommend
SSIS is great for ETL projects, for exporting/importing data into MS SQL, and for moving data between servers. It's an excellent tool for those types of projects and scenarios.

A high-performance ETL product

Rating: 9 out of 10
Incentivized
April 15, 2016
LC
Luca Campanelli
Database Administrator
Intralot Italia S.p.A. (Gambling & Casinos, 51-200 employees)
Vetted Review
Verified User
SQL Server Integration Services
6 years of experience
View profile
Use Cases and Deployment Scope
In our department we use SQL Server Integration Services daily. The main use is to do data processing for several ETL processes. Thanks to the use of SQL Server Integration Services we can upload data to the data warehouse in different ways such as a bulk load or with incremental loads thanks to the use of SCD task data.
Pros
  • High data load speeds
  • Many data processing modes
  • Many data sources and destinations data possible
Cons
  • For some tools you need to integrate third-party packages
  • Depending on the version you must have the right visual studio version to develop and deploy
  • Not really intuitive
Likelihood to Recommend
SQL Server Integration Services is optimal for any process of data extraction, data transformation and data loading, and can be used quickly for massive loads. It can be used for scheduled and incremental processes. It is not optimal for data structures that continuously change their structure because in this case it requires continuous changes and deploys.

SQL BI Stack review

Rating: 7 out of 10
Incentivized
October 27, 2015
NF
Nurvin Flowers
Senior BI Developer/Data Warehouse Developer
Dealertrack (Computer Software, 1001-5000 employees)
Vetted Review
Verified User
SQL Server Integration Services
8 years of experience
Use Cases and Deployment Scope
Used across the organization to move data, develop data marts and build front end reports
Pros
  • There is flexibility to Transform various data. There are also templates that help to guide you in using best practices such as building TYPE 2 loading of Data Warehouse tables
  • There are many transformation features that allow for sorting, lookups, using a variety of data sources and targets. It is a full featured product.
  • There are a lot of properties that allows you to customize data flows to suit your needs.
Cons
  • Having to sort prior to merging is a pain.
  • Working on very large data sets approaching 1 billion records require a lot of pre-planning. Teradata handle large data sets better
  • Error messaging is sometimes not explicit enough. "Something went wrong" is one of my "favorites" that I have seen
Likelihood to Recommend
Well suited for data sets that are not too large < 500,000,000. Not well suited for handling very large data sets.

SQL Server Integration Services: A Great "Free" ETL Tool for Most Use Cases

Rating: 8 out of 10
Incentivized
June 27, 2019
Verified User
Team Lead in Information Technology
Information Technology and Services Company, 10,001+ employees
Vetted Review
Verified User
SQL Server Integration Services
10 years of experience
Use Cases and Deployment Scope
In my work in the health care field, we use SQL Server Integration Services as our default ETL tool of choice for pulling data into SQL Server from Teradata, Oracle, flat file and other SQL Server databases, and for creating data extracts to send to our clients, typically in the form of flat files.
Pros
  • SSIS works very well pulling well-defined data into SQL Server from a wide variety of data sources.
  • It comes free with the SQL Server so it is hard not to consider using it providing you have a team who is trained and experienced using SSIS.
  • When SSIS doesn't have exactly what you need you can use C# or VBA to extend its functionality.
Cons
  • SSIS has been a bit neglected by Microsoft and new features are slow in coming.
  • When importing data from flat files and Excel workbooks, changes in the data structure will cause the extracts to fail. Workarounds do exist but are not easily implemented. If your source data structure does not change or rarely changes, this negative is relatively insignificant.
  • While add-on third-party SSIS tools exist, there are only a small number of vendors actively supporting SSIS and license fees for production server use can be significant especially in highly-scaled environments.
Likelihood to Recommend
SQL Server Integration Services is extremely well built for creating packages to run ETL operations in environments where the structure of the source and/or destination data never or rarely changes, however, it tends to be difficult to maintain packages in production environments where the structure of the data changes frequently.

Use it if you have a Microsoft Stack

Rating: 8 out of 10
Incentivized
August 05, 2016
HN
Hung Nguyen
Technical Analyst BI II (Global Business Intelligence and Analytics - Data Infrastructure)
Ingram Micro (Information Technology and Services, 10,001+ employees)
Vetted Review
Verified User
SQL Server Integration Services
5 years of experience
View profile
Use Cases and Deployment Scope
I cannot say for the whole organization, but we use SSIS for just about all our automation processes. When managing a large data warehouse it is incredibly useful to automate the ETL process. We primarily use it for the data warehouse, but it's versatile enough to use for other automation tasks, reports, and notifications.
Pros
  • Clear GUI and ETL workflow. It's very easy to understand how the data is being managed. When pulling up a SSIS solution that someone else has created, it's very easy to see what's going on-- how the data is extracted, how it is transformed, and how it's being loaded.
  • Deploying scripts. Once a proper package store is configured, you just need to hit deploy and it handles the rest. It's also flexible enough that you can still use SSIS packages without using an SSIS DB for version control by calling them through the file system. Or if you're one of those people who love batch scripts, you can also execute the packages through command line.
  • SSIS Package Store. It's a great way to manage your versions and deployments. Bonus is that if you use a package store, it'll also give you error reports after the fact if a package fails for debugging. It'll tell you exactly what step failed and why.
Cons
  • I think it handles undefined/dynamic data sources poorly. Considering that we use it primarily to ETL data from other systems across the whole organization to bring into our BU's data warehouse, we sometimes have issues when the source has changed. If someone adds a column without letting us know, we'll need to modify the SSIS packages.
  • Sometimes the error codes are vague or cryptic. When debugging a SSIS package I have to google the code or error message and hope someone has a similar issue on stack overflow.
  • SSIS really only works if you're already using a lot of Microsoft Products like Microsoft SQL Server or SQL Server Reporting Services. As mentioned in the name of the application, "integration services", it's designed to integrate your products together so that you can get the most out of it.
Likelihood to Recommend
As mentioned in the pros and cons, SQL Server Integration Services is great when you're running a Microsoft stack. We're loading data from all over into our data warehouses and moving them between other SQL instances all the time. I can whip up a package and deploy it in less than 5 minutes to get our data moving between SQL servers. It integrates really well and is flexible enough that you can supplement any lacking functionality using third party plugins or building your own tools. Although this has been solved in later iterations, SQL Server Data Tools (which is used to build SSIS packages), did not have the functionality to download files from an FTP server using SFTP. I built a C# app that I could run using SSIS.
Return to navigation