SSIS Reviews

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.