SSIS Reviews

We use the on-prem version of this solution. Our primary use case of this solution is for integrated data on the SQL server. 

It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft.

There are a lot of features that could make this solution better. 

There were some issues when we tried to connect it to data storage. It was a connection issue. There is also room for improvement in the underlying language. 

I have been using this solution for three to four months.

It is stable. 

From personal experience, I really can't comment on the scalability, but from what I've seen online, and what I heard from other people is that it scales quite nicely.

I haven't had to contact technical support. 

We previously used an in-house solution based on Oracle APEX.

The initial setup was straightforward.

We used a consultant for the integration.

We chose SSIS because it was a good financial decision. It was the most cost-effective option at the time. 

There are many projects for the company that I work for that requires implementation for a client. I started with it because I just wanted to learn about it, and I had the chance to use it because there was an opportunity that opened up to implement it.

If you have data needs and you are a small or medium enterprise this is a good solution. If you are an organization and you're not dealing with terabytes of data, but you still need to analyze data to make that decision, you should go with this solution.

I would rate it a 7.5 out of ten. 

I am an ETL developer working as an information zone leader. We are an outsourcing company to our customers.

The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle. 

I would like to see SSIS improve the collection of data trail servers and reporting. Future releases should improve the data lineage, as it currently is not good.

I have been using SQL Server Integration Services for five years.

This solution is stable, but the performance is not good. I believe it can be improved. Informatica is better.

I have not been restricted by this solution.

Prior to using SSIS I used Informatica. I switched because my organization is using SSIS.

The initial setup of this solution is not complex. 

Most of the time we do the implementation in-house, however, we have used third parties in the past.

Our license with SSIS is annual.

If an organization has the money, I recommend they use Informatica. 

I would rate SSIS a seven out of 10 overall.

On-premises

Its easy to use, fast to develop. Quite easy to also add C# or other code into ETL flow. Transfer to production is much faster than for example with IBM Infosphere Datastage, you can just copy the packages. Haven't found bugs much at all. Its license cost is also quite cheap compared to IBM and Informatica offerings. Overall when choosing a new ETL software I would look into SSIS or one of the open source tools.

-If you want to connect to SAP for example you have to buy add-in from other company and the same applies to many other sources.

-It doesn't have a built-in version control, so you have to get that from other vendors too (so it lacks support for multiple developers).

-Visual studio crashes sometimes.

-Doesn't have good ELT functionality, though ofcourse one can just do SQL.

-Overall there's many small things that could be done to make development faster and the product is not definitely perfect, but one has to compare to offerings of other vendors, which are not 'perfect' from usability and performance standpoint eather.

Been using it for 5 years now.

Scalability not on the same level as with IBM Datastage.

Many customers are switching from IBM Datastage to SSIS. Think its the ease of use and license costs.

Microsoft SQL Server Integration Services provides you the ability to build ETL solutions with very minimum background knowledge. If you are already familiar with DTS packages or fairly new to ETL, it is very easy for you to start with your first assignment using SSIS.Microsoft SSIS not only provides you the traditional ETL tasks for loading data from source to destination, it also provides you the ability to send emails using it and write your custom code using Script task and offers to process SSAS task, which makes it stand out from its competitors.It is specifically designed to provide high data transfer using parallel computational logic.Very easy to configure and deploy and maintenance is very low.

It is unable to provide separate user account for each user like Data Hub. Actually Microsoft SSIS is more designed to build ETL solutions for enterprise level unlike Data Hub where each user can access the database and have their own sets of databases.Need to improve error logging although it does provide error logs but there is still more room for improvement in this area. Microsoft SQL Server Integration Services is one of the most effective ETL tools available in the market.Microsoft SQL Server Integration Services is very low cost compared to the market’s leader Informatica (Power Center) and almost offers everything you need to build your ETL solution.

You need to have Microsoft SQL Server (Enterprise Edition) licensed to run Microsoft SSIS on your production environment. Like every other Microsoft product, It offers a very vibrant MSDN community along with Microsoft support staff for assistance.

It has good data integration and good processes. 

I would like to see an auto-scheduler feature in the Developer version of this solution.

I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process. 

I have been using this solution for the last three years.

It is stable.

Compared to other solutions, this solution is scalable. 

We only have three users using this solution. 

We haven't had to use their technical support. We don't really have any issues. We only had a problem with the data extraction. 

This is the first tool of this sort that we've used in my company. 

The initial setup was complex. 

We implemented it ourselves. We did the ATL. It was nice in the previous version. There was an issue where we were extracting a big load of data and the system crashed. 

I would rate it a seven out of ten. Not a ten because of the data extraction that crashed. Tableau is better in this aspect. The transformation of data is very good in SSIS. 

The primary use case for this solution varies according to the customer, but it typically involves moving data from OLTP systems into a data warehouse and/or data marts.

This solution has provided an inexpensive tool and it is easy to find experienced developers.

The most valuable features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT.

The UI could use refinement. I would like to see more standard components out of the box, such as SFTP, and data compression components.

More than five years.

We are a software development company and implement solutions like SQL Server SSIS for our clients. We do not use this product ourselves in the company but have experience with it because our client asked for it.

Our clients use it to transform data and generate reports. The use cases are generally simple, and not advanced or complex.

The interface is very user-friendly.

It runs a little bit slowly, although this may be because of our laptops.

I would like to see better integration with Power BI.

The stability is okay. It is easy to support.

There are approximately 10 users. At this time, there are no plans to increase usage.

I have not used technical support. Instead, I read blogs and the support that is available online.

The initial setup is easy, and we did not find it complex.

Our in-house team was responsible for deployment.

I would rate this solution an eight out of ten.