SSIS Scalability

Shubham-Agarwal - PeerSpot reviewer
Manager - Projects at Cognizant

It is a scalable solution. I have around 800-900 users of the solution in our organization.

View full review »
BobAmy - PeerSpot reviewer
Sr. Architect - Data warehousing & BI at Molina Healthcare, Inc.

It can be very scalable both by adding memory or cores, and by running the SSIS on a farm of servers.

View full review »
Sakiru Dosumu - PeerSpot reviewer
Head, Development Chapter (DevOps) at First Bank of Nigeria Ltd.


It is scalable, although there may be some performance issues with very large volumes of data. In my department, around ten users utilize SSIS, but across the organization, it's used by various departments, including those handling webinars, data migration, and communication systems like Avaya.
View full review »
Buyer's Guide
SSIS
March 2024
Learn what your peers think about SSIS. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,386 professionals have used our research since 2012.
Rohit Rastogi - PeerSpot reviewer
Lead Data Engineer at Capgemini

There are six teams using the solution in our company. 

View full review »
PALAK SURI - PeerSpot reviewer
Senior Software Engineer at Eurofins

It is scalable, and we haven't faced many issues. Sometimes, there are storage issues, but it is more of a DBA problem. We have a team in India and France and four people from the Eurofins team using this solution.

View full review »
Krishna_Prasad - PeerSpot reviewer
Business Solutions Specialist at Kuwait Oil Company (K.S.C.)

We have found this to be an easily scalable solution.

View full review »
Arpita-Mishra - PeerSpot reviewer
Specialist Software Engineer at a financial services firm with 10,001+ employees

I'd rate the scalability four out of ten. The solution does not handle large amounts of data well. Azure Data Factory is much, much more scalable. 

View full review »
Eyal Golombek - PeerSpot reviewer
Database administrator at a recruiting/HR firm with 51-200 employees

The scalability is pretty good. I'd rate the ability to expand at a seven out of ten. 

There are only three of us using the solution at this time. 

View full review »
Business Intelligence Architect at a financial services firm with 5,001-10,000 employees

I would recommend SSIS for both smaller and larger companies. We operate as a small to medium-sized enterprise with a considerable volume of data, around 30 to 40 terabytes in our data warehouse. Despite being an SME, SSIS has proven effective in handling our ETL processes seamlessly. If an organization has a similar data size, around the 30 to 40-terabyte range, SSIS can be a suitable and reliable choice for managing their data integration needs.

View full review »
Sakiru Dosumu - PeerSpot reviewer
Head, Development Chapter (DevOps) at First Bank of Nigeria Ltd.

This solution is good for small-scale developments. We have approximately 80 people using the solution.

View full review »
Ullas Soman - PeerSpot reviewer
DevOps Consultant at Coforge Growth Agency

This is a very scalable product. You can expand easily.

We have 200 people using the solution. They are developers. 

View full review »
Syed Fahad Anwar - PeerSpot reviewer
Principal System Developer at HHRC

SSIS is not that scalable. You can scale it vertically to handle a high load, but it lacks horizontal scalability. 

View full review »
DM
Data Architect at AMP Capital

SSIS scales well

View full review »
VS
Senior Associate at PwC Acceleration Centers

SSIS has proven itself in scalability for datasets.

We have more than 500 people using this solution in my organization.

View full review »
Pavel Adam - PeerSpot reviewer
BI specialist at SKODA AUTO a.s.

The current scalability is ok and we have around seven to eight hundred users.

View full review »
SR
IT Manager at European University

The scalability is good.

We do not have a lot of users. The processes we do have run at night.

It's not about how many users use the solution, it's about how many people benefit from it. There are many that benefit from the output.

View full review »
Kerols Alfons - PeerSpot reviewer
Lead Software Engineer at WadiDegla

The scalability of SSIS is good.

We have approximately 10 users using this solution in my company.

View full review »
AS
General Manager IT at a manufacturing company with 10,001+ employees

SSIS is scalable.

View full review »
LD
IT Project Management /Research & Development Team Leader at Ethiopian Roads Administration

The solution is scalable. It's not a problem to expand. 

Currently, we are using it in the development environment, so we have around five users.

Increasing usage depends on the structure that we have. Let's say if the organization plans to increase the structure and the developer number, we might increase usage a bit. For the time being, five is enough.

View full review »
SB
Admin at IEC (Electoral Commission of South Africa)

SSIS is scalable.

View full review »
TY
Technical Consultant at LinkDev

We can scale the solution just fine. 

It is our plan to increase usage in the future. 

We have ten users on the solution right now.

View full review »
Waqar Malik - PeerSpot reviewer
System Analyst at National University of Sciences and Technology

There are three to four people in my company who use SSIS, and around twenty to thirty people are dashboard users.

View full review »
Dhruv Singh - PeerSpot reviewer
Senior Architect (Data and AI) at a tech services company with 1,001-5,000 employees

We have never faced any significant issues as long as your underlying hardware has a good amount of resources.

Scalability depends on the kind of workload and implementation you are giving to SSIS.

It is best suited for small and medium. However, for enterprises, it depends on the specific implementation they require. Real-time scenarios might not be the best fit, but for batch processing, it can still be suitable.

I rate the solution’s scalability an eight out of ten. It essentially gives most of the small and medium use cases, you will be easily able to implement and scale SSIS.

View full review »
ArturKowalczyk - PeerSpot reviewer
Technology Innovation Leader at Netrix S.A.

SSIS is moderately scalable.

The company is fairly substantial. They have approximately 400,000 people in the company, but I am not aware of how many are using this solution. It is quite a bit.

There are a lot of developers using it.

I am not aware if they plan to increase their usage, it is not within my decision.

In terms of my immediate surroundings, we intend to use cloud tools, Azure technologies, and Microsoft. First and foremost, Microsoft ADF. Azure Data Factory is the cloud's SSIS replacement.

View full review »
YY
Manager, Data & Intelligence Group, Technical at a consultancy with 10,001+ employees

The solution could be more scalable. 

View full review »
EL
BI Architect at a retailer with 10,001+ employees

There are limitations. I wouldn't say that it is easy to scale. You can scale it, but I wouldn't say it can easily be done.

We have eight people who use this solution in our company.

View full review »
MB
Project Lead Performance Engineer & Automation at a insurance company with 10,001+ employees

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.

View full review »
AN
CEO at Shiraz University

The solution is scalable.

View full review »
AltanAtabarut - PeerSpot reviewer
ECommerce Growth Analytics at Akinon

The solution is very scalable. We have approximately 25-30 users for the on-premises version, and our cloud version has around 5,000 users.

View full review »
Pavan Yogender - PeerSpot reviewer
Founder and CEO at Zertain

SSIS is a scalable solution.

View full review »
BillyJohn - PeerSpot reviewer
Data Engineer at DataHyv

We have problems with the ports for the analysis services. If everything is deployed, you need to redeploy. It's hard to scale out. If you plan to scale up, you need to prepare everything correctly from the start. Everything needs to be properly configured and deployed. 

View full review »
MJ
Senior Manager Software Development at Techlogix

Yes. It's very much scalable, but it all depends on how you design your solution. SSIS provides you extensive features and toolkit to handle all sort of data problems.

View full review »
MG
Technical Product Owner, Team Lead at ARCA

The scalability of SSIS is very good. Right now, only I am using the solution, but we plan to increase usage in the future.

View full review »
BD
Business Process and Strategy Specialist Advisor at NTTData

SSIS is good for smaller shops that don't really have a high volume of data.

View full review »
MP
Senior Analyst at a tech services company with 1,001-5,000 employees

Almost 10 percent of our users work with SSIS. It's more than a hundred. 

View full review »
IS
Director at Netica d.o.o.

The solution is very scalable. The amount of people that use SSIS from our end depends on the project, so it varies. We increase the usage of this product based on the projects that we get. Basically, each project that we do, we use this solution for integration purposes.

View full review »
Lucas Dreyer - PeerSpot reviewer
Data Engineer at BBD

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.

View full review »
CG
BI Consultant at a tech services company with 201-500 employees

We typically implement the solution for enterprise-size companies.

View full review »
it_user342606 - PeerSpot reviewer
Platform Lead: Global Markets Data Analytics at Rand Merchant Bank

In terms of scalability, we haven't tried big data because in our enterprise we have to use Informatica to connect to the dedupe. I can't say how well it reads with the file, but we've never had an issue. However, I can't speak to scalability because we're never really, really big data.

View full review »
Edgar Talom - PeerSpot reviewer
Information Technology Support Engineer/ Implementation Analyst /DBA at a tech services company with 11-50 employees

If you want to scale SSIS, you might face performance issues. I'm not sure SSIS has robust scalability. 

View full review »
AS
Database Consultant

The solution is very scalable. A client contacted me two months after deployment with a request to enlarge the services and add some more customization, which I managed to do easily. It's an enterprise-level solution, with the whole of Saudi Arabia using it for something called an E-Visa. People are applying for a visa to get into Saudi Arabia through this application. The number of users is quite high and worldwide.

View full review »
SA
Data Architect and Modeler at a tech services company with 201-500 employees

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.

View full review »
it_user1048011 - PeerSpot reviewer
Senior BI Developer at a music company with 501-1,000 employees

The scalability is fairly good. I've used it from very, very small instances to two very large ones, where we're moving large quantities of data on a daily basis.

The actual tool itself, in a sense of transformations, your ability to pick and look up and do certain things is fairly good. Scalability, you can either have it on the same server as the database or you can move it onto its own server. It just depends on the situation.

If you've got a heavy load on the database during the day and you're doing SSIS then you have the option to separate them. But as in our case, which is a data warehouse, you can keep them on the same server because you're getting a lot of your batch processes overnight. So, most of the resources are being used by SSIS. Then during the day, you have the users using the database server for reporting or data capture or data inserts and data updates.

Our users for this solution are primarily BI developers, and we have twenty to twenty-five of them, mostly offshore.

If we grow here then we'll need more SSIS servers, or we'll get bigger boxes. At the moment, I think that we're where we need to be, and I don't have any plans moving forward at this stage.

View full review »
Celine Meesseman - PeerSpot reviewer
Director at Ingenia

We have four customers that are using this product.

View full review »
Shivani Pandey - PeerSpot reviewer
Consultant at Veear Analytics pvt limited

The solution is scalable. In the current use case, we have about 25 users of the solution. 

View full review »
Serdar Erdurak - PeerSpot reviewer
Information Zone Leader at digitallency

I have not been restricted by this solution.

View full review »
RH
Assistant Manager at a tech services company with 10,001+ employees

There were no scalability issues.

View full review »
KS
Owner at 7Spring Consult

Right now we're working with Azure, and it's scalable, but it's expensive to do so. If we had features to scale the software part of the solution, it would be great.

View full review »
JF
BI Consultant at a tech services company with 201-500 employees

From personal experience, I really can't comment on the scalability, but from what I've seen online, and what I heard from other people is that it scales quite nicely.

View full review »
Alexander Samuel Larico - PeerSpot reviewer
Teaching Professional at Next Idea Lab

There are approximately 10 users. At this time, there are no plans to increase usage.

View full review »
it_user275646 - PeerSpot reviewer
Senior Consultant with 51-200 employees

Scalability not on the same level as with IBM Datastage.

View full review »
ST
Software Developer at a transportation company with 1,001-5,000 employees

Compared to other solutions, this solution is scalable. 

We only have three users using this solution. 

View full review »
Buyer's Guide
SSIS
March 2024
Learn what your peers think about SSIS. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,386 professionals have used our research since 2012.