SSIS Valuable Features
The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products.
It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world.
Script task and Script component for custom tasks: It gives you power to build your own logic if your requirements are not being fulfilled with existing available components. While the big thing is you can build your own components, that is not so straightforward.
It's visual design interface is good and you can easily understand the flow.
The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline. It has good logging capabilities as well.View full review »
With this solution, there is the potential to expand so that you can immediately write code onto the SQL server. Auto-parallelization is also critical for us. It decides automatically how many parallel sessions you have to run to get your query handled. You don't need to take care of any code, which is ideal. It's also highly scalable.View full review »
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.View full review »
Some of the valuable features I have found with this solution has been the variety of transformations that are possible and it works well with SQL servers. The majority of our clients that I worked for, their whole systems of data is using SQL server which has worked better for them.
The script component is very powerful, things that you cannot normally do, is feasible through C#. If you can write a script you can import it through the Script Task.
Technical Product Owner, Team Lead at ARCA
I couldn't point out a specific feature above all others, but I can say the solution is very useful to us. It's well designed and quite straightforward. There isn't much of a learning curve involved. It's a well-documented solution.
The workflow features have been very valuable. You can have automated workflows and all the steps are controlled. The workflow functionality of integration services is excellent.View full review »
Software Developer at a transportation company with 1,001-5,000 employees
It has good data integration and good processes.View full review »
Teaching Professional at a tech services company with 1-10 employees
The interface is very user-friendly.View full review »
The most valuable features of this solution are the fast insert and fuzzy logic matching.View full review »
Big Data Architect, Integration Specialist at Groundswell Group Inc
This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language.View full review »