SSIS Overview

SSIS is the #2 ranked solution in our list of top Data Integration Tools. It is most often compared to Informatica PowerCenter: SSIS vs Informatica PowerCenter

What is SSIS?
SSIS is a package is an organized collection of connections, control flow elements, data flow elements, event handlers, variables, parameters, and configurations, that you assemble using either the graphical design tools that SQL Server Integration Services provides, or build programmatically. You then save the completed package to SQL Server, the SSIS Package Store, or the file system, or you can deploy the ssISnoversion project to the SSIS server. The package is the unit of work that is retrieved, executed, and saved.

SSIS is also known as SQL Server Integration Services.

SSIS Buyer's Guide

Download the SSIS Buyer's Guide including reviews and more. Updated: April 2021

SSIS Customers
PKP Energetyka, UniCredit Bank, Mostar, waldwasser, Ashok leyland, Florida Atlantic University, Stadt Frankfurt am Main
SSIS Video

Filter Archived Reviews (More than two years old)

Filter by:
Filter Reviews
Industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
Rating
Loading...
Filter Unavailable
Considered
Loading...
Filter Unavailable
Order by:
Loading...
  • Date
  • Highest Rating
  • Lowest Rating
  • Review Length
Search:
Showingreviews based on the current filters. Reset all filters
Senior Director Business Intelligence at Xtivia
Real User
An inexpensive tool with a short learning curve

What is our primary use case?

The primary use case for this solution varies according to the customer, but it typically involves moving data from OLTP systems into a data warehouse and/or data marts.

How has it helped my organization?

This solution has provided an inexpensive tool and it is easy to find experienced developers.

What is most valuable?

The most valuable features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT.

What needs improvement?

The UI could use refinement. I would like to see more standard components out of the box, such as SFTP, and data compression components.

For how long have I used the solution?

More than five years.
Business Process and Strategy Specialist Advisor at NTTData
Consultant
Top 5Leaderboard
It was a easily adaptable to our group. The scalability needs some improvement.

What is our primary use case?

Movement of data and creation of files. ALl the typical things that you would have a ETL solution do. Data movements were in the millions and no calculations were completed. This means it was always a select * from where ever it was coming from and going to. Light translations like concatenation was being used.
Learn what your peers think about SSIS. Get advice and tips from experienced pros sharing their opinions. Updated: April 2021.
501,151 professionals have used our research since 2012.
VD
student at University of Newcastle
User
A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened. The solution can be deployed into the cloud through Data Factory

What is our primary use case?

SSIS is a very flexible solution that allows data to be generated through code or external software. As a result, we can create reproducible patterns and improve code quality.

How has it helped my organization?

Because of the code generation, code quality improved and the time to develop decreased. This led to a quicker and more agile development phase.

What is most valuable?

It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud.

What needs improvement?

Metadata management. A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened.

For how long have I used the solution?

More than five years.
Assistant Manager at a tech services company with 10,001+ employees
MSP
In addition to the ETL challenges, it allows us to do DBA activitities, scripting and many other tasks.

Pros and Cons

  • "In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
  • "SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."

What other advice do I have?

Don't worry, go ahead.
Business Intelligence Consultant at a tech services company with 51-200 employees
Consultant
All the necessary types of enumerators are available, but writing custom components and sharing them across multiple ETL streams is tricky.

What other advice do I have?

The good: * Straightforward, intuitive, quick to learn * Built-in debugger: variables, data viewers, breakpoints - everything you would expect from a modern software development tool * Sleek, snappy UI * Great flexibility with storing and deploying ETL components The bad: * Third party plug-ins may become incompatible with future versions of SSIS * Upgrading is usually painful and time consuming despite what MS says * Compatibility issues may arise when used with non-Microsoft technologies
Senior Consultant with 51-200 employees
Vendor
It allows us to add C# or other code into ETL flow, but it doesn't have a built-in version control, so you have to get that from other vendors too (so it lacks support for multiple developers).
Developer at a tech consulting company with 51-200 employees
Consultant
Microsoft SQL Server Integration Services is one of the most effective ETL tools available in the market

What other advice do I have?

You need to have Microsoft SQL Server (Enterprise Edition) licensed to run Microsoft SSIS on your production environment. Like every other Microsoft product, It offers a very vibrant MSDN community along with Microsoft support staff for assistance.
Engineer at a tech services company with 501-1,000 employees
Consultant
SSIS vs. BizTalk - which is best for integration with Dynamics Ax
During the last couple of years, I have integrated data with Dynamics Ax both with SSIS and BizTalk. A common question I'm asked is what is the difference when every thing is possible in SSIS why do we need BizTalk or what does BizTalk provide different from SSIS. So My answer to this question is something like: Everything that BizTalk provides can be implemented in SSIS. But the major difference is batch processing. Usually SSIS package are used to migrate large set of data or dataset. BizTalk provide the operations to be perform on one message at time or real time processing. Because everything in BizTalk is XML so BizTalk is very slow on large set of data. BizTalk provides large number of adapters, while In SSIS you have to use direct connection by Oldb, or Sql db to…
Architect at a marketing services firm with 51-200 employees
Vendor
SSIS vs Hadoop
On one corner we have Hadoop, a massively distributed JVM-based data processing engine with a Map & Reduce API and a proven track record in handling huge data-sets. On the other corner we have SSIS, a natively non-distributed ETL engine part of the SQL Server family tool-set with .NET code extensibility features and a drag and drop UI (for the most part anyway). Two sweet technologies, probably shouldn’t be compared to each other but we’re doing it anyway, pitted head to head against a data mapping task to the death (or at least to the recycling of my test VMs)… Now FIGHT! Recently I have been tasked with building a data processing layer tracking social signals with the following characteristics: Input data is flat files. Although initially the amount of data might not…
Product Categories
Data Integration Tools
Buyer's Guide
Download our free SSIS Report and get advice and tips from experienced pros sharing their opinions.