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.3

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

(258)

Attribute Ratings

Reviews

(1-8 of 8)
Companies can't remove reviews or game the system. Here's why
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
Usability
9
If you use any of the Microsoft tools, it is easy to get using and understand since it uses Visual Studio and SSMS to work with. There are extensions you can get and some of those can be difficult to work with but usually they slide in nicely. The one thing to understand though is there is some installation and configuration on the SQL Server side that can take some time.
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
Usability
10
While there is a learning curve, it is possible to successfully implement SSIS in anyone's business with little or no prior experience. The tool's native usability along with a wealth of online resources in a large community means that the user will never be stuck for long.

June 27, 2019

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

Verified User
Team Lead in Information Technology
Information Technology and Services Company, 10,001+ employees
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Usability
9
SSIS is a great tool for most ETL needs. It has the 90% (or more) use cases covered and even in many of the use cases where it is not ideal SSIS can be extended via a .NET language to do the job well in a supportable way for almost any performance workload.
June 07, 2019

SSIS - Strong performer in the traditional data space, but can be improved in handling JSON objects

Verified User
Contributor in Professional Services
Computer Software Company, 51-200 employees
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Usability
8
SSIS has a drag and drop based developer interface, so it is relatively straight forward to get started. You can start to get into the weeds pretty quickly as your solution becomes more complex. However, most of the base functions are right in front of you for a developer. You can also set project and solution level parameters, so when you deploy to new environments, you don't have to jump into each package to change your variables and settings. (For example, default directory to ingest flat files).
January 15, 2019

SQL Server Integration Services: a great tool for small to medium sized implementations

Verified User
Engineer in Information Technology
Automotive Company, 10,001+ employees
Score 6 out of 10
Vetted Review
Verified User
Incentivized
Usability
6
SQL Server Integration Services is a relatively nice tool but is simply not the ETL for a global, large-scale organization. With developing requirements such as NoSQL data, cloud-based tools, and extraordinarily large databases, SSIS is no longer our tool of choice.
April 15, 2016

A high-performance ETL product

Luca Campanelli | TrustRadius Reviewer
Luca Campanelli
Database Administrator
Intralot Italia S.p.A. (Gambling & Casinos, 51-200 employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Usability
8
in terms of usability, sql server integration services is very schematic and very little dynamic, but for the type of software this schematic is physiological.
When you gain the right technical expertise and once you really know the product usability becomes increasingly fast and simple, the important thing is not to be scared on the first approach.
Return to navigation