SSIS Reviews

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.

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.

I was using the solution to implement some business logic. What we do with the data collected is, for example, use it with Excel and some other databases. We do write our own logic to input the data into the SQL server. We'll be taking inputs and putting them into our business logic.

It is a very helpful tool to integrate. We can have our logic ready by putting data from different data sources, and based on our business requirements, we can have the logic created with the help of the SSIS package.

It allows us to use our own logic. We can create our own packages where it can help us to define the business logic.

It is easy to set up. The deployment is also very quick.

It is stable and reliable. 

The product is scalable. 

There aren't any improvements that are required for SSIS at the moment.

We'd like better data lake architecture so we can move SSIS to the data lake if necessary. Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included. 

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

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

This is a very scalable product. You can expand easily.

We have 200 people using the solution. They are developers. 

I've never used technical support in the past. I don't have details as to how helpful or responsive they are. 

The solution is very straightforward. It's not overly complex. 

The package deployment takes some time. It depends on the size of the data which is being pulled in. For the normal setup, it hardly takes much time. For the most part, it is very fast.

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

I'm an end-user.

We are using the latest version of SQL Server 2019. Typically, I start on-prem and move to the cloud. 

It's a good tool for merging data from various data sources. We can have automated administrative functions and data-loading features. We can populate the data for the data warehouse and for data merges. This is one of the best analytic tools for a person or enterprise. We can recommend it for data analysis and data analytics purposes.

I'd rate the solution ten out of ten.

SSIS orchestrates data transformation in the environment, which includes Oracle and SQL Server databases.

The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task.

Connectivity to databases other than Microsoft. This is the Achilles' heel.

Integration with other vendors' connectivity should be available as well as being able to read and write data to databases or data storage other than with Microsoft.

There is connectivity with other databases, however, this is the most significant issue that has to be addressed.

I have been using SSIS for five years, but I first used it in 2007.

SSIS is quite stable.

SSIS is moderately scalable.

The company is fairly substantial. They have approximately 400,000 people in the company, but I am not aware of how many are using this solution. It is quite a bit.

There are a lot of developers using it.

I am not aware if they plan to increase their usage, it is not within my decision.

In terms of my immediate surroundings, we intend to use cloud tools, Azure technologies, and Microsoft. First and foremost, Microsoft ADF. Azure Data Factory is the cloud's SSIS replacement.

For this particular product, we have not used technical support.

I started with SSIS but then switched to IBM Datastage.

That was where I worked, this was already in use at another organization. 

I recently moved jobs, and this is the platform of choice for ETL once again. Informatica data center was used in various other organizations. 

I was attending Informatica workshops. I wasn't Informatica actively, but I might in the future, perhaps soon.

The initial setup is straightforward.

It only took five minutes to deploy SSIS. 

For maintenance, we rely on our platform team.

We will probably need one person for maintenance. Let's say it's only one person. But I'm not speaking on behalf of the entire company; I'm speaking on behalf of a single team of perhaps 1,000 people.

We did not use a consultant or third-party vendor, everything was done in-house.

This is difficult since it is included in the SQL server license. 

Depending on the arrangement that a certain company has with Microsoft, it may supply the permanent license that is included in the SQL server license, or it may be a time-bound license if it is a partner license or other enterprise license. 

I am not sure what our relationship with Microsoft is like or what the program is, but I believe it's some sort of enterprise license.

In the past, I worked with permanent licenses.

I would recommend SSIS to others who would be interested in using it.

I would rate SSIS an eight out of ten.

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.

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.

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.