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.

SSIS (SQL Server Integration Services) is primarily an ETL tool. It's frequently used for data integration and transformation. In the past, we used it to integrate data into our systems. Microsoft is now focusing on Azure Data Factory for cloud solutions, but SSIS is still a viable on-premises option.

SSIS utilizes SQL Server Management Studio (SSMS) for management. I've used SSMS for many years and find it quite user-friendly, even for those new to SQL Server.

Being a Microsoft product, it integrates well with Visual Studio, a familiar development environment. It also has a graphical interface that displays the ETL process step-by-step. 

It's a familiar tool within the Microsoft ecosystem, which has its advantages. 

It lacked robust cloud integration and sometimes struggled with specific data types from sources.

Another area of improvement is performance. It has always been an issue. 

I used it for more than ten years.

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.

Scalability mainly depends on the underlying SQL Server installation. A more powerful server can naturally handle larger data volumes. There might be performance bottlenecks specific to SSIS itself.

There are around two to three end users in my department. There might be more in the company. 

I usually resolve issues on my own.

The setup was easy. All Microsoft products are easy to set up. 

It comes with SQL Server. We didn't have a separate license for it.

It does its job. I'd probably rate it a six out of ten. Performance could be better.

SSIS is a good fit if you're heavily invested in on-premises Microsoft products. If you have a more diverse tech stack, better ETL tools might be available. Microsoft often limits how its products interact with others.

I use the company's solution to build dashboards and back-end data integration with Microsoft SQL Server and Power BI.

The most valuable features of the solution stem from the convenience it offers, along with the ability to refresh data.

The product's stability needs improvement.

The high prices attached to the product can be an area of concern where improvements are required.

I have been using SSIS for two years.

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

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

My company has a database administrator, so we don't use the support provided by the solution in our company.

The efficiency of the deployment and management tools of SSIS is a bit technical, but it is alright since our company's technical support has hands-on experience with it, and they can deal with the deployment part in a very minimal amount of time.

The product's deployment phase is easy.

To deploy the product, I followed the solution's online tutorial and downloaded the tool to configure it.

If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive.

I have managed a complex data transformation process in my company with the solution's transformation functions. Previously, I worked at my company with the data streaming destination in SSIS.

For integration purposes, my company uses SSIS connection managers. With SSIS, I can also get data locally installed in Power BI and design the dashboard.

I mostly rely on the dashboards provided by Power BI instead of SSIS.

I use SSIS for the data integration process. I don't use Power BI that much for the data integration process.

The data warehousing capabilities of SSIS are okay.

If you are not using any product that offers integration services in your company, then you can start using SSIS for your organization's applications.

The debugging and error handling capabilities improved our company's data integration task, as the tool helped me detect many issues.

The benefit of the product is that there are a lot of online tutorials available about the tool. Users will not face any hurdles when trying to search for information about the product online.

I rate the tool an eight out of ten.

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 use SSIS to copy production data to Reporting Repositories. We use it for data movement from and to SQL or flat files such as CSV or fixed data.  This is primarily to build and update a data lake and data warehouse. 

More custom use cases are to do DQ validation comparing source to destination, and to extract data from bat files and SSIS files in order to build a metadata repository for documenting and mapping all the ETL packages.  We use this to find the packages responsible for any particular table or file, or vice versa.  This system, along with statistics logging, also gives us summary reporting capability.

I like that SSIS lets us build programs top-down. Starting with the control section, then drilling into the details of the steps make more sense than what Informatica requires, where you have to build each block first, then use a different tool to build the control structure.

In production, SSIS does a very good job of distributing work to many threads. It is robust and does a good job of handling overload conditions. It is simple for basic jobs, yet able to do very complex tasks. When all else fails, code can be written to make your own custom task or even tool.

I believe SSIS is not given the credit it deserves. SSIS does what most other new vendors tout as great features. But it is a very mature and stable product, unlike those others. It is supported by a larger company than many of those other products.

The error messages are pretty clear and point you to the problem well.

I am disappointed that Azure Data Factory did not stay closer to SSIS.

Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows.

For flexibility and to make reading the logs in case of errors, I prefer not to put multiple copy operations in the same dataflow, although that is possible.  I try to keep in mind how to make production operations as easy as possible in case of failures.  I want to give the night crew the best opportunity for success when an error does occur.

We have about one error per 400 processes. About 3/4 of these were transitory issues with issues like slow connections and temporary outages. By making the code rerunnable, we can auto-restart on any error, and that resolves 3/4 without human intervention. This leaves any failure after two retries the only issue that the night crew has to do Root Cause Analysis (RCA) on.

We purchase an add-on called task factory primarily to allow bulk delete, update, and upsert capability. I'd like to see this be part of the standard package.

I believe there are ways to build a model and set variables so that it can be a generic process.

In my next system, I would like to have a generic process that would handle all the logging and processing in a model that can be modified and enhanced as the need for a better process, or different statistics to be logged is discovered.  I'd want this in a way that the model can be changed and all the processes, with their unique parameters, could all be changed with the model upgraded.

I believe they should add some features that help to create the code using a model. This would allow for continuous improvement of the model uses and easy replication of all the different programs that use the model.

15 years

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

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

I did not really need much.  SSIS has a lot of excellent help available for a web search.

Positive

Prior solutions used SQL triggers

We have more control over the ETL with SSIS.

Installation is quite easy.  There are some drivers and setting you may need to make, based on the sources or sinks you need.  I am hoping these are more embedded in the install process, as I have not set up a server since 2015.

In house.  

good

SSIS is part of SQL server, in itself a very solid product.

You can run SSIS on the same SQL server instance where your data warehouse is, using the compute power at night to update, and during the day for reporting and data analysis.

I did not evaluate other options.  SSIS was available, and it worked well.

I later changed jobs to another company that used SSIS, and worked to improve and grow their data warehouse solution.

After using SSIS, we have tried talend, informatica, and spark solutions.  I would go back to SSIS, even for a non Microsoft shop, if I were allowed to.

We have a consolidated data warehouse. We use an SSIS tool as a pipeline to fetch the data from multiple sources such as Excel, CSV, Oracle database, or APIs. Further, we put the data into the SSIS database. We are using the solution for ETL purposes.

Previously, it took a lot of work to connect with multiple data sources. But now, we can connect with them easily using an external connector in SSIS.

Sometimes, we have issues with SSIS connectors while extracting data from Excel sources. They should improve this particular area for excellent compatibility.

I have been working with the solution for the last ten years.

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.

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

As I have been using the solution for the last ten years, I directly highlighted some questions to Microsoft. It is very easy to reach out to them, and I always receive support from them.

We used Informatica as well. We switched to SSIS as it took a lot of work to set up a pipeline in Informatica. Also, SSIS is more straightforward for the end user. 

The solution's setup was straightforward. It takes a day or two to complete the process. If you are good at development, the deployment process becomes easy. You only need a few resources to deploy the solution. I am handling deployment and maintenance all alone.

The solution is available at a lesser price than that of Informatica. I assume SSIS's enterprise version of SQL Server is pretty costly, but I must be aware.

The solution is easy to maintain. SSIS is a handy tool but requires vast knowledge to build the pipeline using it. I advise others to go for SSIS if the user is versed in developing a pipeline. Otherwise, you can quickly build a pipeline using multiple user-friendly solutions.

I rate the solution as a ten.

The use case is related to all reporting and transactions. On an hourly basis, we will pull the data for a few reports. Most of the time, it is a real-time integration between the applications.

Overall, it's a good product. I haven't had any issues with the product.

They can improve the solution in general. That said, I'm using around 30% to 40% of the SQL server. We have a separate team for the database administration site, so they probably have more of an idea of what needs to be improved.

We've had issues in terms of the amount of data that is transferred when we are scheduling. There are a few restrictions that we faced. In terms of the number of records, the limit can be increased. Sometimes what happens is not enough records are getting pulled, so sometimes the data is getting lost. After that, when the next schedule is running next time, the data is coming to our warehouse for data analysis. We need them to increase the limit of the data transfer on the schedule.

The initial setup was a bit difficult. 

I've been using the solution for seven or eight years.

The first time I attempted to deploy the solution, it was a bit difficult. However, it gets easier with time. 

I'd rate the ease of setup 6.5 out of ten in terms of ease of implementation. 

I don't do much on the deployment side and, therefore, can't speak to how long it takes to actually deploy.

We have around eight people on the solution working on the deployment in total. Around 5 are database administrators and there are three developers. 

I'm not sure which version of the solution I'm using. 

Before starting with SSIS, a person needs to understand the concepts of SSIS. They need some time to get comfortable with the product before jumping in. When I first started, I wasn't aware of a lot of things. Therefore, at first, it was a bit difficult. However, it gets easier with time. 

I'd rate the solution eight out of ten. It's flexible and very effective in terms of PLS skill programming. You can get real-time data from SSIS.

Mostly we are receiving files in either XML or Excel and then we collect them in databases. Sometimes it's CSV and sometimes it is also Excel. Mostly, it is XML.

We have many regulations that we must follow, and this solution helps us manage that. There are rules that we must follow, and we get files in a uniform structure, and we need to import them into databases. Doing it with SSIS saves us a lot of time.

The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work. 

Mostly it was helping us with importing XML files by checking the access and then doing some look-ups and containers to implement loops and things like that mostly. That was quite helpful in terms of saving time. 

Technical support is helpful.

No big improvements are needed at this time. 

At one point, we did have to purchase an add-on.

Since we are not using it for a whole ETL, or for a data warehouse, maybe I'm missing something.

I've been using the solution for almost eight years. 

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. 

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. 

We contacted technical support maybe once. I don't remember when it was, however, once, we had to look at some dump size, and we called Microsoft to help us with that. They did help us, however, it was a very long time ago and I don't remember too many details about the problem or experience. 

While we are using it quite a lot, my understanding is that the company will go with Talend and not SSIS for a data warehouse project. I don't have any influence on that.

That said, we are not going to do any conversion from SSIS to Talend on what exists in our existing project. The data warehouse will be a totally new project, and they will go with Talend.

We did not use any other solution previously.

The initial setup is very easy. I'd rate it an eight out of ten in terms of ease of implementation.

The deployment itself only took a couple of hours. 

The installation that comes with SQL just requires some tweaking with Visual Studio or something like that. We had some problems with maybe deploying the product from the local machine, however, in the end, we solved it.

We have three people handling the initial setup. All of us are DBAs.

We handled the initial setup ourselves, in-house.

There are occasionally add-ons for SSIS that may increase the price. 

In the past, we did not evaluate any other solutions. 

We are end-users. 

The SQL version that we are using is 2019. However, I'm not sure about the exact version of SSIS we're using. We installed it with the 2019 version.

I'd rate the solution eight out of ten. 

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.