SSIS is mainly used for data migration transfer.
General Manager IT at a manufacturing company with 10,001+ employees
Good SFTP connectivity but technical support could be better
Pros and Cons
- "SSIS' best feature is SFTP connectivity."
- "Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."
What is our primary use case?
What is most valuable?
SSIS' best feature is SFTP connectivity.
What needs improvement?
In the next release, SSIS should include automated JSON file management.
What do I think about the stability of the solution?
SSIS is stable.
Buyer's Guide
SSIS
September 2025

Learn what your peers think about SSIS. Get advice and tips from experienced pros sharing their opinions. Updated: September 2025.
869,832 professionals have used our research since 2012.
What do I think about the scalability of the solution?
SSIS is scalable.
How are customer service and support?
Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them.
How was the initial setup?
The initial setup is straightforward.
What's my experience with pricing, setup cost, and licensing?
SSIS' licensing is a little high, but it gives good value for money.
What other advice do I have?
I'd give SSIS a rating of seven out of ten.
Which deployment model are you using for this solution?
Hybrid Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer. Partner

Admin at IEC (Electoral Commission of South Africa)
It's easy to use, so you can spend less time and get more done
Pros and Cons
- "The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."
- "It would be nice if you could run SSIS on other environments besides Windows."
What is our primary use case?
SSIS is helpful when you have tasks in a particular workflow that need to be completed on different schedules. You can start a specific task, and SSIS goes through the workflow to check a few things before it decides whether the task needs to proceed. Right now, maybe a quarter of the company is using it, but we plan to expand use in the future.
What is most valuable?
The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product.
What needs improvement?
It would be nice if you could run SSIS on other environments besides Windows.
For how long have I used the solution?
We use SSIS ad hoc when a problem arises that requires it. We've used it a few times over the last year.
What do I think about the stability of the solution?
SSIS is stable.
What do I think about the scalability of the solution?
SSIS is scalable.
How are customer service and support?
Microsoft support isn't helpful most of the time. We get most of our answers from forums.
How was the initial setup?
Installing SSIS is straightforward and takes an hour or two.
What about the implementation team?
We deployed SSIS in-house.
What was our ROI?
We've seen a return on using SSIS.
What's my experience with pricing, setup cost, and licensing?
An SQL Server license includes licenses for the database engine, reporting services, SSIS, and analysis services. That's the nice thing about this package. When you buy it, you get all of these different add-ons.
What other advice do I have?
I rate SSIS eight out of 10. I would recommend it.
Which deployment model are you using for this solution?
On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Buyer's Guide
SSIS
September 2025

Learn what your peers think about SSIS. Get advice and tips from experienced pros sharing their opinions. Updated: September 2025.
869,832 professionals have used our research since 2012.
Manager, Data & Intelligence Group, Technical at a consultancy with 10,001+ employees
A very user-friendly UI with good adaptability to multiple data sources
Pros and Cons
- "The UI is very user-friendly."
- "Options for scaling could be improved."
What is our primary use case?
This is an infrastructure tool and our primary use case is for data warehouse integration.
How has it helped my organization?
The solution has enabled us to perform tasks more quickly.
What is most valuable?
The UI is very user-friendly and I like that the solution has the ability to adapt to multiple data sources.
What needs improvement?
I haven't found too many successful scaling options and that's something that could be improved.
For how long have I used the solution?
I've been using this solution for over 10 years.
What do I think about the stability of the solution?
The solution is stable.
What do I think about the scalability of the solution?
The solution could be more scalable.
How was the initial setup?
The initial setup is straightforward. The deployment took a day and we did it in-house.
What other advice do I have?
I rate this solution eight out of 10.
Which deployment model are you using for this solution?
On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Integrates well with SQL servers, but technical support needs improvement
Pros and Cons
- "SSIS integrates well with SQL servers and Microsoft products."
- "I would like to see more features in terms of the integration with Azure Data Factory."
What is most valuable?
SSIS integrates well with SQL servers and Microsoft products.
From a cost perspective, it's a cheaper option than other ETL tools.
Also, it has a lot of in-built transformation, and it's easy to learn.
What needs improvement?
I would like to see more features in terms of the integration with Azure Data Factory.
For how long have I used the solution?
I've worked with this solution for about four years, on both the on-premises and cloud solutions. We had around 3000 plus users.
What do I think about the stability of the solution?
It's a stable solution.
How are customer service and support?
Technical support is not efficient, and I've had to search on the web to solve the problems.
Which solution did I use previously and why did I switch?
I worked on PowerCenter.
How was the initial setup?
The initial setup is straightforward and is not complex. It took about a day to install.
You would need two to three technical staff for the deployment and maintenance of the solution.
What about the implementation team?
We used an integrator for the deployment process.
What's my experience with pricing, setup cost, and licensing?
SSIS is a cheaper option compared to the cost of other ETL tools.
What other advice do I have?
SSIS is a cheaper solution, and I would recommend it.
On a scale from one to ten, I would rate it at seven.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Data Architect at AMP Capital
It's easy to integrate data from various sources
Pros and Cons
- "SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together."
- "It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
What is our primary use case?
We use SSIS to integrate investment data we collect from different places into our portfolio management system. We get results out of portfolio management systems and integrate that into the downstream back-office, risk, and regulatory reporting systems. All the developers at my company use it.
What is most valuable?
SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together.
What needs improvement?
It's difficult to refactor SSIS. It gets cumbersome to reuse the solution.
For how long have I used the solution?
I have used SSIS off and on for maybe 15 years.
What do I think about the stability of the solution?
SSIS is stable.
What do I think about the scalability of the solution?
SSIS scales well
How are customer service and support?
I've never had any issues with SSIS, but I'm not responsible for managing the solution at an enterprise level.
Which solution did I use previously and why did I switch?
I've used free solutions or ones that allow you to create your own. I've used free ones like KNIME, etc. The open-source solutions have similar features, but I haven't found one with the same ease of use.
How was the initial setup?
I've never had to install SSIS at an enterprise level, but the installation is straightforward for development purposes. It takes less than an hour. However, installing it at the enterprise level would require a lot more configuration, tuning, etc. I'll leave that to the experts.
What's my experience with pricing, setup cost, and licensing?
We pay for a license, and I think SSIS is priced about right.
What other advice do I have?
I rate SSIS nine out of 10.
Which deployment model are you using for this solution?
On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Senior Analyst at a tech services company with 1,001-5,000 employees
Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface
Pros and Cons
- "You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."
- "Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."
What is our primary use case?
We have data that needs to be migrated. There is also a scan inventory. We create web data, pull it, search it, and then find answers and report stakeholders. So for this process, we use the SSIS.
What is most valuable?
You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive.
What needs improvement?
Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion.
For how long have I used the solution?
We've been using SSIS for about four and a half years.
What do I think about the stability of the solution?
If you run SSIS from the local system, it will lag, but it will work properly if you host on the cloud somewhere. It's a headache every time you run this locally.
What do I think about the scalability of the solution?
Almost 10 percent of our users work with SSIS. It's more than a hundred.
How are customer service and support?
We haven't had that many problems. I have interacted with Microsoft support for some things, but it was a few minor issues. And with the updated VPA, it has been clear. I was satisfied with the support. We don't need support for these types of issues. We don't need to contact the support team or stop our business.
How was the initial setup?
The initial setup is never a complex process because the interface is user-friendly. If you are working with complex situations, then it can get complicated. We have a DBA team to handle the deployment. We must follow a process to deploy, so we need to get approval whenever there is a change. It's not easy for us, but it's still good, and it doesn't take much time.
What's my experience with pricing, setup cost, and licensing?
SSIS is on the cheaper side. In terms of value for the money, rivals are offering more database formats and cost processing, so SQL is lagging somewhat.
What other advice do I have?
I rate SSIS eight out of 10. I recommend it.
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
Project Lead Performance Engineer & Automation at Allstate
Stable, good technical support, and scalable
Pros and Cons
- "The technical support is very good."
- "The solution could improve by having quicker release updates."
What is our primary use case?
We are using SSIS for all of our relational database management systems (RDBMS) data.
What needs improvement?
The solution could improve by having quicker release updates.
For how long have I used the solution?
I have been using SSIS for approximately
What do I think about the stability of the solution?
The solution is stable.
What do I think about the scalability of the solution?
The solution is scalable. With virtualization enabled we are able to scale horizontally.
We have approximately 2,000 users using this solution in our company.
How are customer service and technical support?
The technical support is very good.
Which solution did I use previously and why did I switch?
We have previously used Oracle.
What about the implementation team?
We have approximately 12 administrators and managers that do the implementation and maintenance of the solution.
What's my experience with pricing, setup cost, and licensing?
We have an enterprise license for this solution.
What other advice do I have?
I would recommend this solution to others.
I rate SSIS a nine out of ten.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
BI Consultant at a tech services company with 201-500 employees
Variety of transformations, good SQL integration, and allows C# scripting
Pros and Cons
- "The script component is very powerful, things that you cannot normally do, is feasible through C#."
- "The solution could improve on integrating with other types of data sources."
What is most valuable?
Some of the valuable features I have found with this solution has been the variety of transformations that are possible and it works well with SQL servers. The majority of our clients that I worked for, their whole systems of data is using SQL server which has worked better for them.
The script component is very powerful, things that you cannot normally do, is feasible through C#. If you can write a script you can import it through the Script Task.
What needs improvement?
The solution could improve on integrating with other types of data sources. We had issues with connecting to Oracle, it did not do as good of a job as it did with SQL servers.
In my experience, more efficiency is needed when it comes to dealing with huge volumes of data. However, this is also dependant on the server capacity.
In an upcoming release, they should update the features to facilitate efficient data transfers.
For how long have I used the solution?
I have been using the solution for approximately 10 years.
What do I think about the stability of the solution?
We have not experienced any behavioural differences with the operations of the solution, it is stable.
What do I think about the scalability of the solution?
We typically implement the solution for enterprise-size companies.
How was the initial setup?
The installation was easy.
What's my experience with pricing, setup cost, and licensing?
It would be beneficial if the solution had a less costly cloud offering.
Which other solutions did I evaluate?
Informatica and Talent, are two options I am currently evaluating.
What other advice do I have?
Customers have moved on pass SSIS and use Azure Data Factory, Databricks or something similar. We have a few of our customers looking to moving on to Informatica or Talent. This is how I was led to itcentralstation.com, to learn more about SSIS and how it was compared to Informatica.
I have never had a situation where a particular transformation was not possible in SSIS. We have always been able to meet the demands of our need with SSIS.
I rate SSIS an eight out of ten.
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: September 2025
Product Categories
Data IntegrationPopular Comparisons
Informatica Intelligent Data Management Cloud (IDMC)
Azure Data Factory
Informatica PowerCenter
Teradata
Palantir Foundry
Oracle Data Integrator (ODI)
IBM InfoSphere DataStage
Talend Open Studio
Oracle GoldenGate
SAP Data Services
Qlik Replicate
Fivetran
Denodo
SnapLogic
Alteryx Designer
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?