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
SSIS Feature Ratings
Data Source Connection (2)
50%
5.0
Connect to traditional data sources
90%
9.0
Connecto to Big Data and NoSQL
10%
1.0
Data Transformations (2)
50%
5.0
Simple transformations
50%
5.0
Complex transformations
50%
5.0
Data Modeling (5)
10%
1.0
Data model creation
N/A
N/A
Metadata management
10%
1.0
Business rules and workflow
N/A
N/A
Collaboration
10%
1.0
Testing and debugging
30%
3.0
Data Governance (2)
10%
1.0
Integration with data quality tools
N/A
N/A
Integration with MDM tools
20%
2.0
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
SSIS Feature Ratings
Data Source Connection (2)
70%
7.0
Connect to traditional data sources
90%
9.0
Connecto to Big Data and NoSQL
50%
5.0
Data Transformations (2)
80%
8.0
Simple transformations
90%
9.0
Complex transformations
70%
7.0
Data Modeling (5)
60%
6.0
Data model creation
90%
9.0
Metadata management
80%
8.0
Business rules and workflow
80%
8.0
Collaboration
50%
5.0
Testing and debugging
N/A
N/A
Data Governance (2)
15%
1.5
Integration with data quality tools
N/A
N/A
Integration with MDM tools
30%
3.0
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
SSIS Feature Ratings
Data Source Connection (2)
45%
4.5
Connect to traditional data sources
80%
8.0
Connecto to Big Data and NoSQL
10%
1.0
Data Transformations (2)
70%
7.0
Simple transformations
80%
8.0
Complex transformations
60%
6.0
Data Modeling (1)
40%
4.0
Testing and debugging
40%
4.0
Data Governance
N/A
N/A
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
SSIS Feature Ratings
Data Source Connection (2)
45%
4.5
Connect to traditional data sources
70%
7.0
Connecto to Big Data and NoSQL
20%
2.0
Data Transformations (2)
75%
7.5
Simple transformations
80%
8.0
Complex transformations
70%
7.0
Data Modeling (5)
54%
5.4
Data model creation
70%
7.0
Metadata management
70%
7.0
Business rules and workflow
70%
7.0
Collaboration
N/A
N/A
Testing and debugging
60%
6.0
Data Governance (2)
50%
5.0
Integration with data quality tools
50%
5.0
Integration with MDM tools
50%
5.0
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
SSIS Feature Ratings
Data Source Connection (2)
80%
8.0
Connect to traditional data sources
70%
7.0
Connecto to Big Data and NoSQL
90%
9.0
Data Transformations (2)
95%
9.5
Simple transformations
100%
10.0
Complex transformations
90%
9.0
Data Modeling (5)
72%
7.2
Data model creation
80%
8.0
Metadata management
70%
7.0
Business rules and workflow
90%
9.0
Collaboration
70%
7.0
Testing and debugging
50%
5.0
Data Governance (2)
75%
7.5
Integration with data quality tools
70%
7.0
Integration with MDM tools
80%
8.0
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
SSIS Feature Ratings
Data Source Connection (2)
90%
9.0
Connect to traditional data sources
100%
10.0
Connecto to Big Data and NoSQL
80%
8.0
Data Transformations (2)
95%
9.5
Simple transformations
100%
10.0
Complex transformations
90%
9.0
Data Modeling (5)
72%
7.2
Data model creation
70%
7.0
Metadata management
60%
6.0
Business rules and workflow
80%
8.0
Collaboration
90%
9.0
Testing and debugging
60%
6.0
Data Governance (2)
50%
5.0
Integration with data quality tools
50%
5.0
Integration with MDM tools
50%
5.0
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
SSIS Feature Ratings
Data Source Connection (2)
95%
9.5
Connect to traditional data sources
90%
9.0
Connecto to Big Data and NoSQL
100%
10.0
Data Transformations (2)
85%
8.5
Simple transformations
90%
9.0
Complex transformations
80%
8.0
Data Modeling (5)
90%
9.0
Data model creation
100%
10.0
Metadata management
90%
9.0
Business rules and workflow
80%
8.0
Collaboration
100%
10.0
Testing and debugging
80%
8.0
Data Governance (2)
85%
8.5
Integration with data quality tools
80%
8.0
Integration with MDM tools
90%
9.0
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
SSIS Feature Ratings
Data Source Connection (2)
90%
9.0
Connect to traditional data sources
100%
10.0
Connecto to Big Data and NoSQL
80%
8.0
Data Transformations (2)
85%
8.5
Simple transformations
90%
9.0
Complex transformations
80%
8.0
Data Modeling (5)
80%
8.0
Data model creation
100%
10.0
Metadata management
70%
7.0
Business rules and workflow
80%
8.0
Collaboration
90%
9.0
Testing and debugging
60%
6.0
Data Governance (2)
85%
8.5
Integration with data quality tools
90%
9.0
Integration with MDM tools
80%
8.0
June 24, 2022

Tool for data integration and migration

Rao Tahir | TrustRadius Reviewer
Rao Tahir
DotNet Project Manager
BookingWhizz (Information Technology & Services, 201-500 employees)
Score 8 out of 10
Vetted Review
Verified User
Incentivized
SSIS Feature Ratings
Data Source Connection (2)
80%
8.0
Connect to traditional data sources
70%
7.0
Connecto to Big Data and NoSQL
90%
9.0
Data Transformations (2)
75%
7.5
Simple transformations
70%
7.0
Complex transformations
80%
8.0
Data Modeling (5)
72%
7.2
Data model creation
70%
7.0
Metadata management
60%
6.0
Business rules and workflow
80%
8.0
Collaboration
70%
7.0
Testing and debugging
80%
8.0
Data Governance (2)
80%
8.0
Integration with data quality tools
80%
8.0
Integration with MDM tools
80%
8.0
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
SSIS Feature Ratings
Data Source Connection (2)
100%
10.0
Connect to traditional data sources
100%
10.0
Connecto to Big Data and NoSQL
100%
10.0
Data Transformations (2)
85%
8.5
Simple transformations
90%
9.0
Complex transformations
80%
8.0
Data Modeling (5)
82%
8.2
Data model creation
90%
9.0
Metadata management
90%
9.0
Business rules and workflow
90%
9.0
Collaboration
70%
7.0
Testing and debugging
70%
7.0
Data Governance (2)
80%
8.0
Integration with data quality tools
80%
8.0
Integration with MDM tools
80%
8.0
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
SSIS Feature Ratings
Data Source Connection (1)
90%
9.0
Connect to traditional data sources
90%
9.0
Data Transformations (2)
85%
8.5
Simple transformations
90%
9.0
Complex transformations
80%
8.0
Data Modeling (3)
93.33333333333334%
9.3
Data model creation
100%
10.0
Metadata management
90%
9.0
Collaboration
90%
9.0
Data Governance
N/A
N/A
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
SSIS Feature Ratings
Data Source Connection (2)
50%
5.0
Connect to traditional data sources
100%
10.0
Connecto to Big Data and NoSQL
N/A
N/A
Data Transformations (2)
95%
9.5
Simple transformations
100%
10.0
Complex transformations
90%
9.0
Data Modeling (5)
90%
9.0
Data model creation
90%
9.0
Metadata management
90%
9.0
Business rules and workflow
90%
9.0
Collaboration
100%
10.0
Testing and debugging
80%
8.0
Data Governance (2)
90%
9.0
Integration with data quality tools
90%
9.0
Integration with MDM tools
90%
9.0
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
SSIS Feature Ratings
Data Source Connection (2)
50%
5.0
Connect to traditional data sources
100%
10.0
Connecto to Big Data and NoSQL
N/A
N/A
Data Transformations (2)
80%
8.0
Simple transformations
80%
8.0
Complex transformations
80%
8.0
Data Modeling (5)
N/A
N/A
Data model creation
N/A
N/A
Metadata management
N/A
N/A
Business rules and workflow
N/A
N/A
Collaboration
N/A
N/A
Testing and debugging
N/A
N/A
Data Governance (2)
N/A
N/A
Integration with data quality tools
N/A
N/A
Integration with MDM tools
N/A
N/A
December 08, 2021

Provides value to cost and excellent with MSBI Stack, But needs more features/updates

Verified User
Engineer in Information Technology
501-1000 employees
Score 7 out of 10
Vetted Review
Verified User
Incentivized
SSIS Feature Ratings
Data Source Connection (2)
50%
5.0
Connect to traditional data sources
90%
9.0
Connecto to Big Data and NoSQL
10%
1.0
Data Transformations (2)
75%
7.5
Simple transformations
90%
9.0
Complex transformations
60%
6.0
Data Modeling (5)
24%
2.4
Data model creation
N/A
N/A
Metadata management
N/A
N/A
Business rules and workflow
30%
3.0
Collaboration
40%
4.0
Testing and debugging
50%
5.0
Data Governance (2)
N/A
N/A
Integration with data quality tools
N/A
N/A
Integration with MDM tools
N/A
N/A
May 03, 2021

Great product to consolidate data for SQL Reporting purposes

Verified User
Professional in Information Technology
Hospital & Health Care Company, 10,001+ employees
Score 8 out of 10
Vetted Review
Verified User
Incentivized
SSIS Feature Ratings
Data Source Connection (2)
60%
6.0
Connect to traditional data sources
70%
7.0
Connecto to Big Data and NoSQL
50%
5.0
Data Transformations (2)
75%
7.5
Simple transformations
80%
8.0
Complex transformations
70%
7.0
Data Modeling (2)
75%
7.5
Business rules and workflow
70%
7.0
Testing and debugging
80%
8.0
Data Governance (1)
80%
8.0
Integration with data quality tools
80%
8.0
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
SSIS Feature Ratings
Data Source Connection (2)
80%
8.0
Connect to traditional data sources
100%
10.0
Connecto to Big Data and NoSQL
60%
6.0
Data Transformations (2)
90%
9.0
Simple transformations
100%
10.0
Complex transformations
80%
8.0
Data Modeling (4)
67.5%
6.8
Metadata management
80%
8.0
Business rules and workflow
70%
7.0
Collaboration
50%
5.0
Testing and debugging
70%
7.0
Data Governance (2)
65%
6.5
Integration with data quality tools
90%
9.0
Integration with MDM tools
40%
4.0
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
SSIS Feature Ratings
Data Source Connection (2)
45%
4.5
Connect to traditional data sources
90%
9.0
Connecto to Big Data and NoSQL
N/A
N/A
Data Transformations (2)
80%
8.0
Simple transformations
90%
9.0
Complex transformations
70%
7.0
Data Modeling (5)
50%
5.0
Data model creation
N/A
N/A
Metadata management
N/A
N/A
Business rules and workflow
80%
8.0
Collaboration
80%
8.0
Testing and debugging
90%
9.0
Data Governance (2)
N/A
N/A
Integration with data quality tools
N/A
N/A
Integration with MDM tools
N/A
N/A
April 30, 2021

SQL Server Integration Services is the Best Tool for ETL developers

freida oliver | TrustRadius Reviewer
freida oliver
ETL Developer
IBM (Education Management, 10,001+ employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
SSIS Feature Ratings
Data Source Connection (2)
40%
4.0
Connect to traditional data sources
80%
8.0
Connecto to Big Data and NoSQL
N/A
N/A
Data Transformations (2)
100%
10.0
Simple transformations
100%
10.0
Complex transformations
100%
10.0
Data Modeling (5)
34%
3.4
Data model creation
N/A
N/A
Metadata management
N/A
N/A
Business rules and workflow
80%
8.0
Collaboration
N/A
N/A
Testing and debugging
90%
9.0
Data Governance (2)
45%
4.5
Integration with data quality tools
90%
9.0
Integration with MDM tools
N/A
N/A
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
SSIS Feature Ratings
Data Source Connection (2)
80%
8.0
Connect to traditional data sources
90%
9.0
Connecto to Big Data and NoSQL
70%
7.0
Data Transformations (2)
85%
8.5
Simple transformations
90%
9.0
Complex transformations
80%
8.0
Data Modeling (2)
65%
6.5
Business rules and workflow
70%
7.0
Testing and debugging
60%
6.0
Data Governance (2)
80%
8.0
Integration with data quality tools
80%
8.0
Integration with MDM tools
80%
8.0
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
SSIS Feature Ratings
Data Source Connection (2)
80%
8.0
Connect to traditional data sources
80%
8.0
Connecto to Big Data and NoSQL
80%
8.0
Data Transformations (2)
95%
9.5
Simple transformations
100%
10.0
Complex transformations
90%
9.0
Data Modeling (5)
84%
8.4
Data model creation
90%
9.0
Metadata management
100%
10.0
Business rules and workflow
80%
8.0
Collaboration
80%
8.0
Testing and debugging
70%
7.0
Data Governance (2)
85%
8.5
Integration with data quality tools
90%
9.0
Integration with MDM tools
80%
8.0
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
SSIS Feature Ratings
Data Source Connection (2)
50%
5.0
Connect to traditional data sources
100%
10.0
Connecto to Big Data and NoSQL
N/A
N/A
Data Transformations (2)
50%
5.0
Simple transformations
100%
10.0
Complex transformations
N/A
N/A
Data Modeling (5)
40%
4.0
Data model creation
N/A
N/A
Metadata management
N/A
N/A
Business rules and workflow
100%
10.0
Collaboration
N/A
N/A
Testing and debugging
100%
10.0
Data Governance (2)
N/A
N/A
Integration with data quality tools
N/A
N/A
Integration with MDM tools
N/A
N/A
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
SSIS Feature Ratings
Data Source Connection (2)
50%
5.0
Connect to traditional data sources
100%
10.0
Connecto to Big Data and NoSQL
N/A
N/A
Data Transformations (2)
100%
10.0
Simple transformations
100%
10.0
Complex transformations
100%
10.0
Data Modeling (5)
48%
4.8
Data model creation
N/A
N/A
Metadata management
N/A
N/A
Business rules and workflow
90%
9.0
Collaboration
70%
7.0
Testing and debugging
80%
8.0
Data Governance (2)
N/A
N/A
Integration with data quality tools
N/A
N/A
Integration with MDM tools
N/A
N/A
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
SSIS Feature Ratings
Data Source Connection (2)
85%
8.5
Connect to traditional data sources
100%
10.0
Connecto to Big Data and NoSQL
70%
7.0
Data Transformations (2)
80%
8.0
Simple transformations
100%
10.0
Complex transformations
60%
6.0
Data Modeling (5)
66%
6.6
Data model creation
50%
5.0
Metadata management
50%
5.0
Business rules and workflow
70%
7.0
Collaboration
80%
8.0
Testing and debugging
80%
8.0
Data Governance (2)
80%
8.0
Integration with data quality tools
90%
9.0
Integration with MDM tools
70%
7.0
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
SSIS Feature Ratings
Data Source Connection (2)
100%
10.0
Connect to traditional data sources
100%
10.0
Connecto to Big Data and NoSQL
100%
10.0
Data Transformations (2)
100%
10.0
Simple transformations
100%
10.0
Complex transformations
100%
10.0
Data Modeling (5)
66%
6.6
Data model creation
40%
4.0
Metadata management
40%
4.0
Business rules and workflow
90%
9.0
Collaboration
70%
7.0
Testing and debugging
90%
9.0
Data Governance (2)
N/A
N/A
Integration with data quality tools
N/A
N/A
Integration with MDM tools
N/A
N/A
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
SSIS Feature Ratings
Data Source Connection (2)
100%
10.0
Connect to traditional data sources
100%
10.0
Connecto to Big Data and NoSQL
100%
10.0
Data Transformations (2)
90%
9.0
Simple transformations
100%
10.0
Complex transformations
80%
8.0
Data Modeling (5)
72%
7.2
Data model creation
100%
10.0
Metadata management
70%
7.0
Business rules and workflow
90%
9.0
Collaboration
30%
3.0
Testing and debugging
70%
7.0
Data Governance (1)
60%
6.0
Integration with MDM tools
60%
6.0
Return to navigation