SSIS Reviews

This is an infrastructure tool and our primary use case is for data warehouse integration.

The solution has enabled us to perform tasks more quickly.

The UI is very user-friendly and I like that the solution has the ability to adapt to multiple data sources. 

I haven't found too many successful scaling options and that's something that could be improved.

I've been using this solution for over 10 years. 

The solution is stable. 

The solution could be more scalable. 

The initial setup is straightforward. The deployment took a day and we did it in-house. 

I rate this solution eight out of 10. 

We primarily use SSIS to collect data from one system and transfer it to another.

The Classical ETL processing of data.

It's a competent product. You can do a lot of things with it and learn how to use it. You can't do modern things with it, but you can do legacy things with it.

It is an out-of-date product, that we shouldn't be using anymore, as it no longer has many positive aspects.

It is an old tool. We make an effort not to use it. It's a legacy tool, that is nearing the end of its useful life. There could be some good things but we try not to get into that.

We have selected to go with another tool. SSIS should not be used whatsoever anymore. There are new versions, that are cloud-based, which are much more improved and much more feature complete.

We have been working with SSIS for 15 years.

We are working with the latest version. It hasn't been updated for many years.

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.

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.

Support is available, but it is no longer up to date. It needs to be improved.

We switched to Data Factory, which is the cloud version of SSIS and the primary reason for the switch.

Absolutely, the initial setup is a simple process. In my opinion, it's easy.

SSIS doesn't require any maintenance.

The deployment was completed internally.

It comes bundled with other solutions, which makes it difficult to get the price on the specific product.

It's actually a tool that we're attempting to eliminate. That should not be used. It's an old piece of equipment. That should not be used in any way.

If I was asked five or six years ago, I would recommend this solution, but not anymore.

I would rate SSIS an eight out of ten.

We primarily use the solution for data transformation.

The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions. Also, the use of the configuration on Azure. Our clients are basically secret sever based, so it works well there.

In terms of improvements to the solution, I don't think I have that expertise on it to recommend product enhancements right now. I've only used a few parts of it. Based on what I've used so far, I am happy with it.

I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use.

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

We've never had to contact technical support. We generally handle any issues ourselves.

The initial setup is straightforward. Deployment is done by another team. I download the package and deliver it to them and they deploy it onto the cloud. In terms of maintenance, we only need one person.

We are using the 2014 Public Cloud version of the solution, under Microsoft Azure.

In terms of recommending the solution, it obviously depends on the level users you have. If you mainly have a simple graphical based user then maybe you could go for SSIS. If you want to take control of the whole ETL process, you should look for another tool. I use Informatica PowerCenter as well. That's a bit more of a robust ETL solution.

I would rate the solution at six out of ten.

SSIS' most valuable feature is its reporting services.

SSIS sometimes hangs, and there are some problems with servers going down after they've been patched.

I've been using SSIS for over eight years.

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

The initial setup was pretty simple.

SSIS is fairly well-priced - I would rate it at four out of five.

SSIS is best suited for small and medium companies. I would rate SSIS eight out of ten.

It's too early to say how it has improved my organization, as we've just begun using the solution. First, we need to create the appropriate role before we see organizational improvements. We're just in the discovery phase of the tool.

I couldn't point out a specific feature above all others, but I can say the solution is very useful to us. It's well designed and quite straightforward. There isn't much of a learning curve involved. It's a well-documented solution. 

It's at a very early stage in terms of adopting the tool, so I can't speak to if there are areas for improvement just yet.

Video training would be a helpful addition, however.

The stability of the solution is impressive.

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

I haven't required any technical support, so I'm not in a position to judge it.

The setup is straightforward. It's very easy to install.

We did the implementation ourselves.

We did not evaluate other options before choosing this solution.

We are just beginning development with this solution, so we're currently starting with the on-premises version.

So far, I haven't been disappointed by the tool. I have not explored the dashboard tuning feature yet, so I don't know if there are things we can do, like building our own matrixes or choosing deployment preferences, but I hope that will be the case.

I'd rate the solution ten out of ten.

We use this solution for ETL, which includes data summation and cleaning. 

This solution used in an on-premise deployment, for now.

I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import.

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.

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.

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.

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.

For the most part, we started with this solution. 

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.

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.

This solution was already in place. That's what is available and it's what people know. Going forward, this will most likely change.

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.

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.

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. 

I have been using the solution for approximately 10 years.

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

We typically implement the solution for enterprise-size companies.

The installation was easy.

It would be beneficial if the solution had a less costly cloud offering.

Informatica and Talent, are two options I am currently evaluating.

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.

We primarily use the solution for integration packages for ETL in order to build data warehouses.

The workflow features have been very valuable. You can have automated workflows and all the steps are controlled. The workflow functionality of integration services is excellent.

The solution should offer more information online for users of SSIS. There are only a few general data sources available, but it would be helpful if there was more extensive information.

The solution could also use some more intelligent discs for data manipulation, or maybe some artificial intelligence as well. It needs more integration tools, so you can connect to different sources.

The solution is quite stable.

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.

Technical support is quite good.

I've always used SSIS. We never considered any other solution. We might have used some tools that were developed in-house occasionally, but by and large, we always use SSIS.

The initial setup was straightforward.

We use the on-premises version of the solution.

I would recommend the solution to others. I'd give it a rating of eight out of ten.