SSIS

SSIS

Customer Verified
About TrustRadius Scoring
Score 8.2 out of 100
SQL Server Integration Services

Overview

Recent Reviews

Worth of money

10 out of 10
June 23, 2022
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 12 features
  • Simple transformations (57)
    8.8
    88%
  • Connect to traditional data sources (57)
    8.7
    87%
  • Complex transformations (56)
    7.8
    78%
  • Testing and debugging (52)
    6.9
    69%

Reviewer Pros & Cons

View all pros & cons

Video Reviews

Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of SSIS, and make your voice heard!

Pricing

View all pricing
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?

8 people want pricing too

Alternatives Pricing

What is Fivetran?

Fivetran replicates applications, databases, events and files into a high-performance data warehouse, after a five minute setup. The vendor says their standardized cloud pipelines are fully managed and zero-maintenance. The vendor says Fivetran began with a realization: For modern companies using…

N/A
Unavailable
What is SolarWinds Task Factory?

According to the vendor, SolarWinds Task Factory saves time managing tedious ELT/ETL tasks with high-performing SQL Server Integration Services (SSIS) components that can be used within the Visual Studio environment to connect to nearly any data source. Task Factory’s components and tasks have been…

Features Scorecard

Data Source Connection

7.6
76%

Data Transformations

8.3
83%

Data Modeling

7.8
78%

Data Governance

7.4
74%

Product Details

What is SSIS?

Microsoft's SQL Server Integration Services (SSIS) is a data integration solution.

SSIS Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

Microsoft's SQL Server Integration Services (SSIS) is a data integration solution.

Reviewers rate Simple transformations highest, with a score of 8.8.

The most common users of SSIS are from Enterprises (1,001+ employees) and the Information Technology & Services industry.

Comparisons

View all alternatives

Reviews and Ratings

 (257)

Ratings

Reviews

(1-6 of 6)
Companies can't remove reviews or game the system. Here's why
Steven Gockley, MBA, MCSA | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
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.
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
Score 6 out of 10
Vetted Review
Verified User
Review Source
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.