- Compatibility with the rest of Microsoft BI stack
- Scripting component which opens unlimited possibilities: by having the full .Net stack/libraries available, if you need a yellow rubber duck to quack every million rows, it will quack
- Inter-stream dependency mechanism built directly into the tool; the whole ETL solution can be driven off it without having to employ third party software
- Parallel processing of a data flow: let's say there's five steps in the flow and ech step consumes output from the preceding step; once step #1 is completed and its data passed to step #2, the engine will feed the next batch of rows to step #1. Once the first batch of rows reaches the last step, there are five concurrent steps working on five different data sets, maximizing utilization of server resources
- All the necessary types of enumerators (files, xml nodes, rows and many more)
Business Intelligence Consultant at a tech services company with 51-200 employees
All the necessary types of enumerators are available, but writing custom components and sharing them across multiple ETL streams is tricky.
What is most valuable?
How has it helped my organization?
- SSIS packages are stored in XML-like format; we keep them in SVN which makes it very easy to track changes
- Built-in dependency tool is really great; you can not only react to success/failure results, but you can evaluate any expression in the flow and execute (or bypass) any components based on the result of that expression. This gives you full control to build decision trees of any complexity
What needs improvement?
- Writing custom components and sharing them across multiple ETL streams is tricky and requires specialistic voodoo knowledge
- Make the GUI less eye-candy and more responsive; especially the scripting component needs some TLC regarding UI responsiveness
How was the initial setup?
It's easy to deploy, you just need a simple file-copy mechanism that is sufficient for most deployment scenarios.
Buyer's Guide
SSIS
March 2025

Learn what your peers think about SSIS. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
844,944 professionals have used our research since 2012.
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
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Data Architect and Modeler at a tech services company with 201-500 employees
Works well for small and medium-sized projects, but additional SQL connectors need to be supplied
Pros and Cons
- "The initial setup of this solution is very straightforward."
- "The performance of this solution is not as good as other tools in the market."
What is our primary use case?
We use this solution for extracting data from various databases and saving it in our data warehouse.
We use the on-premise deployment model.
What needs improvement?
My team is facing problems regarding the database connectors, which are not available. The MySQL connectors need to be purchased from outside vendors. They should provide connections for more SQL databases, free of charge.
The performance of this solution is not as good as other tools in the market. Compared to the same job is running in a different tool, it will take longer using SSIS.
For how long have I used the solution?
I have been working with this solution for one year.
What do I think about the stability of the solution?
This is a stable solution.
What do I think about the scalability of the solution?
This solution is scalable.
The number of people I have using this solution depends on the size of the project. Normally, I need three to five ETL developers. Sometimes, if the project is big enough, then I will need more.
How are customer service and technical support?
I have not contacted Microsoft Technical Support for this solution, although we have sometimes accessed the internet to research problems that we face.
Which solution did I use previously and why did I switch?
In my previous company, I was leading a team who were working with Informatica. Here, they stick to Microsoft technologies and are unwilling to change.
How was the initial setup?
The initial setup of this solution is very straightforward. In a few hours, everything was up and running.
What other advice do I have?
The decision to use this particular solution includes many factors. Some companies do not want to purchase a license for another product because this one comes included with the database.
SSIS worked well for small or medium-sized Projects. For larger projects with huge data, I believe that you should search for another solution as you will need to do manual fine tuning. Additionally, some components such as SCD will show unexpected errors with huge data.
As Microsoft is very slow in providing updates and enhancements to SSIS, I see that the future for Integration projects in Saudi Arabia goes towards other vendors products such as Informatica powercenter, IBM DataStage, and Oracle ODI.
Compared to other Integration tools, I would rate it a six out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
MySql connectors do not need to be purchased. Just use ado.net connector and ODBC. That's been a part of SSIS for a decade. I've used it for Mysql before without any issues. This is all well documented and available from many forums.
Buyer's Guide
SSIS
March 2025

Learn what your peers think about SSIS. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
844,944 professionals have used our research since 2012.
Business Process and Strategy Specialist Advisor at NTTData
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.
How has it helped my organization?
SSIS was easily adaptable to our group. It was cheaper than the other tools that we compared it to, however I feel that we got what we paid for.
What is most valuable?
The packaging and how it is organized is good for someone that really has never seen ETL before.
What needs improvement?
Scalability of SSIS needs some improvement. Seems to get sluggish as soon as we hit a high volume of data.
For how long have I used the solution?
Still implementing.
What do I think about the stability of the solution?
Again it failed a lot and by a lot I mean every day. The failures were false alarms and caused many sleepless night for our company that I used to work for.
What do I think about the scalability of the solution?
SSIS is good for smaller shops that don't really have a high volume of data.
How are customer service and technical support?
I would rate the customer service as poor.
Which solution did I use previously and why did I switch?
We were using Hyperion Application Link. We switched because HAL was being sunset.
How was the initial setup?
Never participated in the initial setup.
What about the implementation team?
In-house.
What was our ROI?
For the money, it's a decent tool. However, if the budget was larger I would have gone with a different tool
What's my experience with pricing, setup cost, and licensing?
Look at how this product is sold to you. Ask yourself, am I getting everything that I need. Its more expensive to get the additional adapters after the fact.
Which other solutions did I evaluate?
We looked at ODI, Informatica, and DataStage. All three we had in-house. ODI was the better option and after dealing with SSIS for only a few months, we ended up using ODI.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Curious people's experiences when they mention "fail a lot" or scalability. I've used many ETL tools in my career - most of them very expensive and I'd put SSIS up against any of them for reliability and performance (within limits).
Scalability is largely comparing to expectations and it depends on your expectations. I think people too often compare completely different architectures and are surprised when they scale differently. SSIS is single server. No MPP going on here folks. You get a lot more than you've paid for (which is really nothing is you already own SqlServer). SSIS sure beats the open source stuff I've seen out there that really sucks. Try Pentaho written in Java if you want slow. I've read where people have custom coded front ends to fire multiple SSIS servers and there's ways of partitioning data flows but if you are getting into that you might be on the wrong tool. Consider the opposite - most people are running SSIS on the target database box so its competing with the database server as well as not utilizing more than one server. I'm doing that and actually getting quite great performance (again - its all about expectations).
So yes if you need millions per second SSIS is not the tool you want. My benchmark with SSIS is @10,000 rows per second to stage large rows through a data flow. I'm guessing if you need a lot faster than that you have significant volumes and big pockets so why would you look at a free tool that's designed to be installed on a database server?
As for failing, it would only fail due to buffers if you did something with altering buffers that you should not have done. That would be your bad sorry. Or you're doing something else silly like running on 4gb VM and didn't set a max memory on the Sql Server so basically everything crawls or fails. Hey - some of you are laughing but some are probably scratching their heads and asking, so what's wrong with that?
Data Engineer at BBD
A strong solution for batch processing with good community support
Pros and Cons
- "I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
- "This solution needs full support for real-time processing."
What is our primary use case?
We use this solution for ETL, which includes data summation and cleaning.
This solution used in an on-premise deployment, for now.
What is most valuable?
I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import.
What needs improvement?
The synchronous processing needs to be improved. For batch processing, it works fine, but when you start to do real-time processing, I find that this solution is not strong, depending on how you use it. If you use it for short batches, micro batching, that might work, but it is not as good for queuing real-time processing. This solution needs full support for real-time processing.
The solution needs better support for XML and JSON.
For how long have I used the solution?
I've been using this solution for the past ten years.
What do I think about the stability of the solution?
I use this product extensively, on a daily basis. It is stable.
Over time, I think we'll most likely start to decrease usage. This will happen as we move to more real-time processing, and we will most likely start to do more queue processing. In terms of batch processing, it will scale down considerably.
What do I think about the scalability of the solution?
In the catalog, it's supposed to be scalable. I think that it has support for an SQL cluster.
In my opinion, I think it's a bit more limited in terms of scalability, although it scales with the database. I would say that the scalability is intermediate in terms of being able to launch multiple instances, or it could do load balancing as well. I think that would be a bit more challenging.
How are customer service and technical support?
We haven't needed to contact Microsoft technical support. When we have trouble we usually use Google to search for what we need to find out. Also, in terms of issues, there's a lot of information on SQLServerCentral and Stack Overflow.
Which solution did I use previously and why did I switch?
For the most part, we started with this solution.
How was the initial setup?
The initial setup of this solution is pretty much straightforward.
If you want to develop with Visual Studio then you have to install the data service add-ons afterward, so it is a bit cumbersome. Then, if you want to use the catalog on the database, with deployment there are often security issues and you have to get an SQL catalog up and running. This can also be a bit cumbersome.
I would say that it takes a day or two to deploy this solution in a new environment, and it can be completed by one or two people. A single developer may be sufficient to deploy and maintain the system.
What about the implementation team?
I implemented some of this myself and had help in terms of setting up the security. There are often security settings that require the assistance of a DBA.
Which other solutions did I evaluate?
This solution was already in place. That's what is available and it's what people know. Going forward, this will most likely change.
What other advice do I have?
My advice to anybody implementing this solution is to look into whether to use it on a catalog in a database, versus using package deployment. There are pros and cons to both approaches in terms of deployment and security. I would say that's something that needs to be evaluated quite early. There are lots of benefits to the catalog, but also a bit more admin attached to it.
Another consideration is real-time processing needs. If this is a requirement then I would recommend against using this solution, unless the next version has a new set of features specifically for real-time processing.
I would rate this solution an eight out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Assistant Manager at a tech services company with 10,001+ employees
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."
How has it helped my organization?
For the full version of the SQL Server, SSIS, SSAS and SSRS will come as additional features for free. Hence, my organization need not spend extra money for other ETL, reporting and analysis tools. This can give very good flexibility.
What is most valuable?
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.
What needs improvement?
SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc. Also, handling of the different data types will be a big challenge here; so expecting improvement in these areas.
What do I think about the stability of the solution?
There were no stability issues.
What do I think about the scalability of the solution?
There were no scalability issues.
How are customer service and technical support?
Technical support is very good.
Which solution did I use previously and why did I switch?
Based on the client's requirements, we switched over to this solution.
How was the initial setup?
The setup is straightforward.
Which other solutions did I evaluate?
We looked at Informatica and DataStage.
What other advice do I have?
Don't worry, go ahead.
Disclosure: My company has a business relationship with this vendor other than being a customer:

Brian DandeneauBusiness Process and Strategy Specialist Advisor at NTTData
Top 5LeaderboardConsultant
Thanks for the review and keep them coming.
I like what you put in here for improvements. However, don't hold your breath for Oracle Cloud integration. Most Oracle ETL/ELT tools don't have direct cloud integration yet and its not on the roadmap for a few years.
V/r,
Brian Dandeneau
CEO Applied Governance
Big Data Architect, Integration Specialist at Groundswell Group Inc
Easy to implement and supports many connectors, but performance-tuning requires extensive expertise
Pros and Cons
- "This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
- "Tuning using this solution requires extensive expertise to improve performance."
What is our primary use case?
Our primary use for this solution is to move data between points and applications.
How has it helped my organization?
This is a flexible tool to use and comes with the MSSQL server package.
What is most valuable?
This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language.
What needs improvement?
Tuning using this solution requires extensive expertise to improve performance.
For how long have I used the solution?
We have been using this solution for fifteen years.
What's my experience with pricing, setup cost, and licensing?
This solution is included with the MSSQL server package.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Engineer at a tech services company with 501-1,000 employees
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 communicate with different database and depend on OlDb connections. In BizTalk large number of Adapter provided to communicate which may or may not be depend on OlDB connection. Build in Tracking system (BAM) and its display on BAM portal is also big advantage on SSIS. For this purpose you have to make a custom tracking system in SSIS which require a lot of coding. Third advantage of BizTalk over SSIS is BRE. Business rule engine. BRE provide the condition whose value can be changed and complete follow of BizTalk application. These BRE roles can be used in multiple biztalk application while these functionality can be achieved on config files in SSIS.
In conclusion, when we required less data integration/migration and require complex decision making we used BizTalk. For example we have to implement complex work flow on single record. BizTalk application also used route data, read from one location, transform it and drop on other location. A simple example of this transactional data, when one transaction is occur in one system and its impact or integration will required on other system we will use BizTalk. BizTalk is a rapid development tool as compare to SSIS.
When we have a large sum of data, we require less complexity and requirement of integrated systems are based on Same technology then we have to use SSIS. Usually SSIS is used to migrate or integrate the non-transaction data or step up data. The delay of migration and integration possible or example Batch processing. SSIS is built for ETL process, it is not rapid integration tool.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
But I think the cost is a big factor to go for biztalk or ssis
Information Zone Leader at digitallency
A stable solution but performance could be better
Pros and Cons
- "The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
- "Future releases should improve the data lineage, as it currently is not good."
What is our primary use case?
I am an ETL developer working as an information zone leader. We are an outsourcing company to our customers.
What is most valuable?
The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle.
What needs improvement?
I would like to see SSIS improve the collection of data trail servers and reporting. Future releases should improve the data lineage, as it currently is not good.
For how long have I used the solution?
I have been using SQL Server Integration Services for five years.
What do I think about the stability of the solution?
This solution is stable, but the performance is not good. I believe it can be improved. Informatica is better.
What do I think about the scalability of the solution?
I have not been restricted by this solution.
Which solution did I use previously and why did I switch?
Prior to using SSIS I used Informatica. I switched because my organization is using SSIS.
How was the initial setup?
The initial setup of this solution is not complex.
What about the implementation team?
Most of the time we do the implementation in-house, however, we have used third parties in the past.
What's my experience with pricing, setup cost, and licensing?
Our license with SSIS is annual.
What other advice do I have?
If an organization has the money, I recommend they use Informatica.
I would rate SSIS a seven out of 10 overall.
Which deployment model are you using for this solution?
On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner

Buyer's Guide
Download our free SSIS Report and get advice and tips from experienced pros
sharing their opinions.
Updated: March 2025
Product Categories
Data IntegrationPopular Comparisons
Informatica Intelligent Data Management Cloud (IDMC)
Azure Data Factory
Informatica PowerCenter
Teradata
Oracle Data Integrator (ODI)
Talend Open Studio
IBM InfoSphere DataStage
Palantir Foundry
Oracle GoldenGate
SAP Data Services
Qlik Replicate
Denodo
Alteryx Designer
Fivetran
SnapLogic
Buyer's Guide
Download our free SSIS Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- Which ETL or Data Integration tool goes the best with Amazon Redshift?
- Which ETL tool would you recommend to populate data from OLTP to OLAP?
- Microsoft SSIS vs. Informatica PowerCenter - which solution has better features?
- What Is The Biggest Difference Between Informatica PowerCenter and Microsoft SSIS?
- What is the biggest difference between SSIS and Pentaho?
- What are the pros and cons of SSIS?
- Which is better - SSIS or Informatica PowerCenter?
- When evaluating Data Integration, what aspect do you think is the most important to look for?
- Microsoft SSIS vs. Informatica PowerCenter - which solution has better features?
- What are the best on-prem ETL tools?
Thanks Gary. Yes, I am aware of the new SSISDB database and I am slowly migrating some of the projects to it. It is much more convenient, especially the way you can configure your solution on per-environment basis. Plus it is flexible, too. You can have just one instance of the SSISDB database for all your environments or one instance per environment, or even some hybrid mode. You can control and track progress of your executions using purely T-SQL, so lots of goodies. Haven't had a chance to play around with 2016 yet but things seem to be going in the right direction anyway.