SSIS Reviews

I am using SSIS for a primary database.

Not much but served as better alternative

The most valuable features of SSIS are that it works with the query language and it can import data from different sources. 

SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data.

I have been using SSIS for approximately seven years.

SSIS is stable.

SSIS has proven itself in scalability for datasets.

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

I have not contacted support.

Positive

The initial setup of SSIS is easy. The full deployment took approximately one hour.

When my company evaluated other solutions we chose SSIS because it was the most reliable solution in the market.

This solution was one of the easiest versions to use compared to other vendors' solutions. I would recommend SSIS to others.

I rate SSIS a nine out of ten.

This solution has all the functions needed. It is a complete solution and they are always adding additional features.

One of our primary use cases is working with issues related to the electronic components of cars.

The most important features are it works well and provides self-service BI.

I would like to see better technical documentation because many times information is missing.

I have been working with SSIS for the past two or three years.

I have found the stability to be acceptable.

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

I am working with technical support currently on two open tickets and there seems to be some type of bug. They have not yet fixed these two open customer support tickets.

I would definitely recommend SSIS and I would rate SSIS a seven on a scale of one to ten.

We use the product sometimes to implement some ETL processes.

We have to transform some data from students so that we can help to make some decisions on what we call deterioration. We receive a lot of data from the government, and sometimes we have to split it into several parts as it is a huge amount of data. We have to put it in a standardized way. We use the solution as a product. It is one of the use cases that we do. When we have other systems, like for staff to control, we also use SSIS since it's appropriate to our system, and we need to put it in certain ways so that we can read it and manage it. 

It is the most valuable for staff processes in order to gain efficiency. It allows us to get the data normalized easily.

The solution is stable.

It can scale well.

The deployment process is very easy and quite quick.

They have good documentation. 

We'd like them to develop data exploration more. 

The support could be better.

I've been using the solution for more than five years. 

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. 

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.

I've never used technical support. Microsoft does have a very good document library, however, if you have an issue and need support, it can take a very long time to get help.

Neutral

How easy or difficult the setup is depends on the size of the process that we want to normalize. If it is a big ETL, it's not always that fast. We are considering changing to a different platform so that it's easier. For example, we are looking into SQL to have another kind of data exploration.

The first time we initially set it up, it was quite fast. The deployment of the integration services for the very first time without any process implemented took about a day.

We handled the setup internally. We did not have to worry about dealing with any consultants or integrators. 

We have yearly licensing.

We are currently looking into SQL to see if it would be easier to use. 

We already have an enterprise contract with Microsoft. We didn't want to spend money on other solutions.

We still have a few versions running. The one that we use the most is the 2017 version.

I'd recommend the solution to others. I'd rate it seven out of ten.

If you are deploying a data strategy for your company, you need more than SSIS. If you need to go fast and implement some ETL processes with no help, it's quite easy to do and learn.

I have been using SSIS for approximately six years.

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

The scalability of SSIS is good.

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

I have not used the support from SSIS.

The initial setup of SSIS is easy.

I rate the initial setup of SSIS a five out of five.

We purchased the standard edition of SQL Server and SSIS came with it free of charge.

My advice to others that want to implement SSIS is they should watch a video or a tutorial for eight hours to implement a project for ETL. If you would like to migrate to SSIS, and link to the data sources, it will take approximately 30 minutes to watch a video tutorial on YouTube. You can search for the topic you are wanting to do, and you'll find the solution. There is a huge community to find the tutorials you need.

I rate SSIS an eight out of ten.

SSIS is mainly used for data migration transfer.

SSIS' best feature is SFTP connectivity.

In the next release, SSIS should include automated JSON file management.

SSIS is stable.

SSIS is scalable.

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.

The initial setup is straightforward.

SSIS' licensing is a little high, but it gives good value for money.

I'd give SSIS a rating of seven out of ten.

The one internally also developed some applications for some specific problems. For that use case, we are using the solution for different purposes, for example, for integration between data disks to databases, as well as for the application level side of integration. We are using the SSIS service actually. And we also have different expertise on the database level. We're also using it for different scenarios. We use it with Microsoft products. It's a part of our strategy, in the data aspect.

The performance is good.

It's easy to use. 

The visibility is great.

We have found the solution to be very straightforward to set up.

The solution is stable.

It can scale well. 

Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options. 

I've been using the solution for ten years or more.

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.

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.

The good thing with Microsoft is you can have support online even without engaging directly with Microsoft. Things are very cloud sensitive. You can also request help from the vendor. Less than two years ago, in 2021, Microsoft stopped offering assistance to those using the on-prem solution.

However, in those cases, you can still find support and answers online, from different users' experiences. There's lots of information out there about Microsoft. It's not hard to get help and find answers. 

Positive

I'm not sure what we used ten to 12 years ago. It has been a long time since we started using this particular solution. 

The solution is straightforward and simple. It's not overly complex or difficult. It's actually quite easy for us to get everything up and running. We can finalize everything within a day. It doesn't take a lot of time to implement it. 

One person is enough to deploy and maintain the solution. That said, it depends on an organization's planning strategy. It might not take a lot to do that kind of activity.

Usually, we handle the setup in-house. However, we have in the past had the help of a consultant or using a supplier. 

With the cloud deployment, you can get a three or five-year license. You may not be able to get an on-premises version anymore. 

I've used the 2014, 2016, and 2019 versions of the product.

I'd recommend the solution to others.

I would recommend the solution to others.

Overall, I can rate the solution an eight out of ten. We're pretty happy with it.

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. 

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.

We use SSIS ad hoc when a problem arises that requires it. We've used it a few times over the last year.

SSIS is stable.

SSIS is scalable.

Microsoft support isn't helpful most of the time. We get most of our answers from forums. 

Installing SSIS is straightforward and takes an hour or two.

We deployed SSIS in-house. 

We've seen a return on using SSIS. 

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.

I rate SSIS eight out of 10. I would recommend it. 

The solution is a business application. It's used for integrations between different databases, migrating from one to one, and importing data from one thing to something else.

Overall, it works well. 

The performance is good.

It's saved time using visualization descriptions. 

The initial setup is straightforward. 

The product is scalable.

It's stable. 

We find the solution to be reasonable. 

We have faced some problems, mostly from a different provider with different language handling.

We'd like the solution to increase the types of integrations on offer. We'd like more integration capabilities. 

I've been using the solution for 20 years. 

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

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.

I've never used technical support. I cannot speak to how helpful or responsive they would be if we needed assistance. 

We did not previously use another solution. 

The solution is straightforward to set up. It's not overly complex. It takes about half an hour to set up.

We have five people that can handle deployment or maintenance tasks. 

We can handle the initial setup on our own. We do not need outside assistance from integrators or consultants. 

The solution is fairly priced. I'd rate it four out of five in terms of affordability.

My company is a Microsoft partner, and we use multiple Micorosft products.

We're using the latest version of the solution. 

I'd recommend the solution to other users and companies. 

I'd rate the solution eight out of ten.