SSIS Stability

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

In terms of stability, SSIS is reliable and easy to use compared to other solutions.

View full review »
Shubham-Agarwal - PeerSpot reviewer
Manager - Projects at Cognizant

It is a very stable solution. We have been creating a solution in SSIS, deploying it into the server, and scheduling it using SQL Server jobs. All the jobs have been running easily and quickly for the last ten years.

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

Very mature and stable, and already has great performance features.

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.
768,578 professionals have used our research since 2012.
Rohit Rastogi - PeerSpot reviewer
Lead Data Engineer at Capgemini

It is quite a stable product. There are no bugs or glitches, and it doesn't crash or freeze. It is reliable. I'd rate it a three or four out of five in terms of stability.

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

We use this solution with Visual Studio. Sometimes we open certain files without making changes, and it saves the changes. In Visual Studio, while we're using TFS, it is easy to backtrack the changes, and we can undo them. However, those changes are pushed to another server if we are not alert and in a hurry.

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

This is a very stable and dependable solution.

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

It is quite stable. It's safe and reliable. A lot of organizations are using it instead of Azure Cloud.

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

The tool's stability is okay. Stability-wise, I rate the solution an eight out of ten.

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

The performance is very good. It makes it easier to do things that you would have to do differently otherwise.

I'd rate the overall stability eight out of ten. We haven't had any stability issues in many years. 

View full review »
XZ
Integration developer at Blackwoods

It is a stable product. I would rate the stability an eight out of ten. 

I don't believe SSIS is a major development focus for Microsoft right now. Performance enhancements are always a concern.

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

I would rate the stability of SSIS at a solid nine out of ten. While there may be occasional encounters with bugs or performance issues, personally, we haven't faced significant problems in our usage. 

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

SSIS is stable.

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

The solution is stable. The performance is good. There are no bugs or glitches. It doesn't crash or freeze.

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

The SSIS is highly stable, but there are occasional issues with the script component.

View full review »
DM
Data Architect at AMP Capital

SSIS is stable. 

View full review »
VS
Senior Associate at PwC Acceleration Centers

SSIS is stable.

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

I have found the stability to be acceptable.

View full review »
SR
IT Manager at European University

The solution is stable. We haven't had any issues with that. If we need more processing power, we can increase the resources of the machines below it. 

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

SSIS is stable, but extensive ETL data processing can have some performance issues.

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

SSIS is stable.

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

The solution is stable and reliable. The performance is good. There are no bugs or glitches. It doesn't crash or freeze. For us, it's worked quite well.

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

SSIS is stable.

View full review »
TY
Technical Consultant at LinkDev

It's very stable and reliable. There aren't bugs or glitches. It doesn't crash or freeze. The performance is fine. 

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

The solution is pretty mature.

I rate the solution’s stability a nine out of ten.

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

SSIS is quite stable.

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

The solution is stable. 

View full review »
Anil Jha - PeerSpot reviewer
Director D&A at Iris Software Inc.

It's a stable solution.

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

I would say it's both reliable and stable. It's been on the market for 20 years, so it's a very mature product.

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

The solution is stable.

View full review »
AN
CEO at Shiraz University

The stability is very good and I recommend it to my friends, my coworkers, and the other companies.

View full review »
AltanAtabarut - PeerSpot reviewer
Solution Consulting, Growth, Analytics at Akinon

The stability of the solution is perfect.

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

SSIS is a stable solution.

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

SSIS is a stable product, but the problem is with the UI you use to build things. If you have it deployed on a virtual machine, everything crashes sometimes. That's one of the significant problems we face with Microsoft products.

View full review »
Vichitra Mohan - PeerSpot reviewer
Technical Service Team Manager at a tech vendor with 10,001+ employees

SSIS' stability is fairly good, but there's room for improvement.

View full review »
MJ
Senior Manager Software Development at Techlogix

I've been using it for last 7 years in different projects for different banks. Didn't face any stability issues yet.

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

The stability of the solution is impressive.

View full review »
SP
Principle Consultant at Keyrus South Africa

The solution is currently running in production. It's stable.

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

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.

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

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.

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

The solution is quite stable.

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

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.

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

We have not experienced any behavioural differences with the operations of the solution, it is stable.

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

The solution is quite stable. I don't think we've had any issues.

View full review »
AS
Database Consultant

The solution is stable, as long as you provide good infrastructure for the servers you're dealing with. That means making sure the SQL will be very stable as well as the SAN storage, the RAM, the CPU, and other components of the server. It is quite important.

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

This is a stable solution.

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

The stability is very good. I've been using it for a long time. If you know how to use it then it works fairly well.

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

The stability is good.

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

We have a stability problem because when something works, it works one time. The next time, it doesn't work. We don't know what is causing that problem. 

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

This solution is stable, but the performance is not good. I believe it can be improved. Informatica is better.

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

There were no stability issues.

View full review »
KS
Owner at 7Spring Consult

The solution is stable.

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

It is stable. 

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

It is stable.

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

The stability is okay. It is easy to support.

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.
768,578 professionals have used our research since 2012.