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-6 of 6)
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
Performance
8
Raw performance is great. At times, depending on the machine you are using for development, the IDE can have issues. Deploying projects is very easy and the tool set they give you to monitor jobs out of the box is decent. If you do very much with it you will have to write into your projects performance tracking though.
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
Performance
9
I haven't experienced any issues worth mentioning in terms of SSIS performance. But it is worth mentioning that there is a HUGE difference between tools and with different configurations within the app. I've seen a single data flow task go from over 30 minutes to less than one with the right configuration.

There should be more tools to enable process tuning to improve package performance.... although the software itself runs smoothly with very few interruptions.
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
Performance
10
You can, of course, accidentally make sloppy code or workflows but it’s not a tools issue if you run packages in an inefficient way. With a company of our size, we never had any performance issues but I can imagine for larger companies that this will have a greater focus.
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
Performance
9
SSIS packages tend to run, anecdotally, slower than expected in large volume data processing environments and is sometimes better used to prototype high-performance workloads than the execute them. This is a classic case of "your mileage may vary" in a sense that for most workloads I have experienced SSIS has proven more than fast enough to get the job done. In one case, one where live web server data was being streamed into SQL Server in a web-scale ad serving system, SSIS was clearly not fast enough to keep up at any scale--and this was a very rare case.
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
Performance
8
Performance is relative to how you implement your solutions. Proper architecture and design are crucial regardless of what tool you select for your data solutions. That being said, SSIS performs relatively well from a performance standpoint.
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
Performance
6
SQL Server Integration Services performance is dependent directly upon the resources provided to the system. In our environment, we allocated 6 nodes of 4 CPUs, 64GB each, running in parallel. Unfortunately, we had to ramp-up to such a robust environment to get the performance to where we needed it. Most of the reports are completed in a reasonable timeframe. However, in the case of slow running reports, it is often difficult if not impossible to cancel the report without killing the report instance or stopping the service.
Return to navigation