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 53)

SSIS Cheap and easy to use

Rating: 7 out of 10
Incentivized
October 29, 2015
PM
Pancratius Mukeh
BI Consultant
Saxony Partners (Information Technology and Services, 11-50 employees)
Vetted Review
Verified User
SQL Server Integration Services
6 years of experience
Use Cases and Deployment Scope
We use SQL Server Integration Services to pull data from FTP sites.
Pros
  • Our clients have branches and each branch generates a flat file and loads to a remote site from which we pull and consolidate the data and report from the consolidated data.
  • SSIS would allow [us] to execute a batch file which will pull the files and decrypt.
  • SSIS transformations are easy to use when [they] loop around the files in the same folder.
Cons
  • SSIS expressions are difficult to read and comprehend.
  • SSIS fuzzy loop up transformation performance needs to be optimized.
  • SSIS packages code should be easy to copy and modify so that it can easily be replicated just like BIML.
Likelihood to Recommend
Can SQL Server Integration Services (SSIS) perform multiple unrelated tasks within a package?

Our use of SSIS

Rating: 9 out of 10
Incentivized
November 24, 2019
Verified User
General Manager in Information Technology
Non-Profit Organization Management Company, 11-50 employees
Vetted Review
Verified User
SQL Server Integration Services
2 years of experience
Use Cases and Deployment Scope
We use SQL Server Integration Services to import data into and out of our main SQL server databases. This data comes from a variety of external sources and sometimes there is data format mismatch between source and destination. With an SSIS package, we can retain the mapping and data formats integrity from the source to the destination without having to go through the process every time.
Pros
  • Easy to manage projects and packages.
  • Ideal for repetitive tasks.
  • Can handle complex tasks consisting of multiple, diverse packages.
Cons
  • Include SSIS in the default installation of SQL.
  • The flexibility and different packages and options can make it confusing for first-time users.
  • Recommendations in the selections could make it easier to build a solution.
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.

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.

Data integration and migration are made easier with this tool.

Rating: 9 out of 10
Incentivized
June 24, 2022
SR
Shubham Rawat
Data Analyst
DayToDay Health (Hospital & Health Care, 201-500 employees)
Vetted Review
Verified User
SQL Server Integration Services
2 years of experience
View profile
Use Cases and Deployment Scope
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 tools is awesome as it is easy to integrate Microsoft SQL servers with different BI tools like google data studio and PowerBI.
Pros
  • Assists in connecting to several data sources and loading the resulting data.
  • Less expensive than other ETL tools of same stature.
  • Does away with the requirement for coding scripts.
Cons
  • There isn't a lot of room for building user-required automation.
  • Some activities need manual labour, such as exporting multiple tables in CSV format one at a time.
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.

SSIS is great if when used in the right place

Rating: 8 out of 10
Incentivized
May 23, 2016
Use Cases and Deployment Scope
Ee create master data management and workflow software for oil and gas companies which involves getting and writing data to other systems. We use SSIS for all integration as it helps dealing with different systems.
Pros
  • Makes it very easy to move data form one system to another
  • So many out of the box transformations
  • The script task gives you so much flexibility as you can write C# code to do almost anything
  • Easy deployment and configuration after the 2012 release
Cons
  • Project deployment model to allow deployment of single packages
  • Allowing to apply one transformation on all columns, like changing all column types from nvarchar to varchar instead of doing it one by one
  • Mamed parameters from inline SQL statments using OLEDB command, currently they are called parameter 1, parameter 2...etc., which is confusing when you have many paramters
  • Pass authorization tokens when calling remote processes like a console application, currently being called as anonymous
Likelihood to Recommend
if you don't have an Sql Server license or are deploying to any OS other than Windows you need to consider a different technology.
Return to navigation