SSIS Reviews

It was used for a couple of purposes, for example, we used it in our data warehouse when we wanted to create a dashboard that would give us an idea about, for example, the data itself. We had a client that would ask about a couple of requirements, like the past data from the last month or last year for a particular region for a particular client, and so on. I was using SSIS to store data incrementally and show the data using SSIS. 

For example, if we have created a couple of tasks or schedules, we would create a couple of packages and schedule them overnight. Every night it could fetch the data incrementally from the data warehouse. Every week, there was a requirement from the client that I need to add particular data to be changed and shared over email weekly. That particular data could be fetched from the data warehouse, and it will be shared with the client every week. 

Many features are very good in SSIS. 

I can create a particular package, and I don't need to repeat it again and again. For example, I can create a package that will fetch all the data from the given data. If my client gives me some data, I can clean some data, perform some transformations, and then store the data in any place. That's quite helpful for me as well. I don't have to do it again and again manually. I just have to create a package, schedule it, and it could be run, and it could be stored in any target I have. It can run for me, again and again, without me having to re-make it manually again and again.

It is easy to set up the product.

There are a couple of areas that could be improved. For example, if I created a package and the package would work on specific data, it could work on the performance or speed of the action. If you are working on a very large amount of data, then creating this package and performing some transformations might take some time. Everything just needs to be faster.

I haven't used SSIS for the last year, so I'm not sure about its new releases as of now.

In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade.

I'd like to see more dashboarding to be able to see the data through a graph. It would be great if I could also share the visualization with my clients.

I did use it in my previous organization for almost one year.

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.

There are six teams using the solution in our company. 

I've never had to reach out to technical support. 

I'm not using Palantir Gotham. I just read about Palantir Gotham, and I'm not using it.

One of my clients wants us to use SSIS, and frankly speaking, if given the opportunity, I would say yes to using SSIS.

With SSIS, it is not difficult at all to set up. Many sources are there through which you can learn how to set up your SSIS. The documentation is great. With the help of documentation, it was very easy for me to set up.

Deploying a package would also not take a lot of time. It depends on what kind of package it is, however, it is pretty fast.  

I'm not aware of the exact cost of the solution. 

I was a user. 

If you want to perform some transformation or data warehouse and the product is used for data analysis purposes, it's a good option. You can perform some transformation, et cetera.

I'd rate the solution eight out of ten. It was very useful for day-to-day tasks.

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.

We're SSIS for flat file data ingestion. Our data sources are Excel files, but if the data sources are SQL servers, I use store procedures instead of SSIS packages.

SSIS is easy to use. 

SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model. 

I have used SSIS for three or four months. 

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.

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. 

We decided to use SSIS because most developers know SQL Server. If they need to hire data engineers, they can just use generic languages like SQL Portal. You don't need to know Talend or other data warehouses and database engines. They prefer SQL Server because that's the most common product.

Setting up SSIS is difficult. I rate it seven out of 10 for ease of setup. It takes around a week to setup a simple data warehouse with three tables. 

I rate SSIS six out of 10. SSIS can get the job done for bigger datasets. However, SQL Server lags if you're working with more than a terabyte or petabyte of data. I recommend exploring the tool because most of the video tutorials on the internet are outdated, and the official Microsoft documentation is geared toward advanced users. Beginners will have a hard time. You need a senior engineer to teach you, or you must explore the tool on your own.

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.

We use this solution as an ETL tool to move large volumes of data from one server to another.

We like that this solution includes a developer edition, free of charge, to allow for training.

This solution is a free, additional feature with an SQL database license, which we appreciate.

We would like the solution to be expanded so that it is available for other platforms than just Microsoft.

We would also like to see this product improved so that the the tool can handle streaming data, and near real-time data capture.

We have been using this solution for more than 20 years.

This is a very stable and dependable solution.

We have found this to be an easily scalable solution.

The initial setup of this solution was very straightforward, and only took a couple of minutes.

We implemented this solution using our in-house team.

This solution is a free of charge addition to our SQL licence. However, the only way this tool can be utilized is as a feature of the SQL licence, which may make it unattractive to organizations who don't wish to purchase the wider-ranging licence.

We highly recommend this solution as it is comparable with all of the major ETL software on the market. However, it should be noted that this is an enterprise class tool; it requires a team to be commissioned to do the proper development, there is a lot of standard documentation that comes with it, and a permanent team will be required to maintain it. So whilst it is a high-performing product, it requires a lot of commitment to optimize its use and capabilities.

I would rate this solution a nine out of ten.

We are using SSIS for applications in development and in production. We have applications that need to have a database to support them and those applications need to have different integration with other applications.

The most valuable feature of SSIS is its ease of use. It is easier to use than other applications.

The performance of SSIS could improve when comparing it to Oracle Database.

I have been using SSIS for a long time.

SSIS is stable.

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

I have used the support from SSIS and I am satisfied.

I would recommend this solution to others.

I rate SSIS a seven out of ten.

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.