SSIS Reviews

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.

We are using SSIS for ETL and ELT in a business intelligence context. We bring in data from different sources and use SSIS transform and load it into our intermediate database where we are developing dashboards. There are three people doing configuration and about 50 end-users. 

SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code.

SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality.

We have been using SSIS for four years now.

The SSIS is highly stable, but there are occasional issues with the script component.

SSIS is not that scalable. You can scale it vertically to handle a high load, but it lacks horizontal scalability. 

Microsoft has some support for SSIS, but because the company is increasingly transitioning to the cloud, so these on-prem solutions are becoming obsolete.

The initial setup isn't too difficult, but it's not easy. Sometimes, you may need help from a database administrator to set up the SQL Server Integration Services. It can take almost a day to deploy. 

A database administrator can deploy it alone. You may need another person to develop the packages and set up ETL, so it's you need about two or three people for deployment in all. 

SSIS is included at no additional cost in the SQL Server license.

I rate SSIS seven out of 10. I would recommend using a cloud solution if possible, but if you need an on-prem product, SSIS is a good option. If you want to start using SSIS, there is a learning curve because SSIS isn't an easy solution to use. It's complicated, so you have to learn about the components and their functionalities to use them to meet your requirements. 

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. 

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. 

SSIS integrates well with SQL servers and Microsoft products.

From a cost perspective, it's a cheaper option than other ETL tools.

Also, it has a lot of in-built transformation, and it's easy to learn.

I would like to see more features in terms of the integration with Azure Data Factory.

I've worked with this solution for about four years, on both the on-premises and cloud solutions. We had around 3000 plus users.

It's a stable solution.

Technical support is not efficient, and I've had to search on the web to solve the problems.

I worked on PowerCenter.

The initial setup is straightforward and is not complex. It took about a day to install.

You would need two to three technical staff for the deployment and maintenance of the solution.

We used an integrator for the deployment process.

SSIS is a cheaper option compared to the cost of other ETL tools.

SSIS is a cheaper solution, and I would recommend it.

On a scale from one to ten, I would rate it at seven.

We use SSIS to integrate investment data we collect from different places into our portfolio management system. We get results out of portfolio management systems and integrate that into the downstream back-office, risk, and regulatory reporting systems. All the developers at my company use it. 

SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together.

It's difficult to refactor SSIS. It gets cumbersome to reuse the solution. 

I have used SSIS off and on for maybe 15 years.

SSIS is stable. 

SSIS scales well

I've never had any issues with SSIS, but I'm not responsible for managing the solution at an enterprise level.

I've used free solutions or ones that allow you to create your own. I've used free ones like KNIME, etc. The open-source solutions have similar features, but I haven't found one with the same ease of use.

I've never had to install SSIS at an enterprise level, but the installation is straightforward for development purposes. It takes less than an hour. However, installing it at the enterprise level would require a lot more configuration, tuning, etc. I'll leave that to the experts.

We pay for a license, and I think SSIS is priced about right. 

I rate SSIS nine out of 10. 

We have data that needs to be migrated. There is also a scan inventory. We create web data, pull it, search it, and then find answers and report stakeholders. So for this process, we use the SSIS.

You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive.

Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion. 

We've been using SSIS for about four and a half years. 

If you run SSIS from the local system, it will lag, but it will work properly if you host on the cloud somewhere. It's a headache every time you run this locally.

Almost 10 percent of our users work with SSIS. It's more than a hundred. 

We haven't had that many problems. I have interacted with Microsoft support for some things, but it was a few minor issues. And with the updated VPA, it has been clear. I was satisfied with the support. We don't need support for these types of issues. We don't need to contact the support team or stop our business. 

The initial setup is never a complex process because the interface is user-friendly. If you are working with complex situations, then it can get complicated. We have a DBA team to handle the deployment. We must follow a process to deploy, so we need to get approval whenever there is a change. It's not easy for us, but it's still good, and it doesn't take much time. 

SSIS is on the cheaper side. In terms of value for the money, rivals are offering more database formats and cost processing, so SQL is lagging somewhat. 

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

We are using SSIS for all of our relational database management systems (RDBMS) data.

The solution could improve by having quicker release updates.

I have been using SSIS for approximately 

The solution is stable.

The solution is scalable. With virtualization enabled we are able to scale horizontally.

We have approximately 2,000 users using this solution in our company.

The technical support is very good.

We have previously used Oracle.

We have approximately 12 administrators and managers that do the implementation and maintenance of the solution.

We have an enterprise license for this solution.

I would recommend this solution to others.

I rate SSIS a nine out of ten.