SSIS Valuable Features

SeniorBI67
Senior BI Developer at a music company with 501-1,000 employees
We use everything in this solution, including a third party component called COZYROC. We try to explore and use this product to its fullest. View full review »
DScientist
Data Scientist at a tech vendor with 501-1,000 employees
I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import. View full review »
AhmedShaban
Database Consultant
I like that the data connections and all ODB connections are able to retrieve data from so many different databases. That's not only from SQL but also from other data sources as well. The data flow, which controls the data, including where to store it, is an excellent feature and is one of the most interesting points about SQL Integration Services. The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great. View full review »
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration Tools. Updated: August 2019.
366,756 professionals have used our research since 2012.
Alireza Nikseresht
CEO at Shiraz University
Usually, when I want to import data from other databases I use this solution. It's been about fifteen years that I've worked with an SQL server, and I'm a software developer. I've had many companies with different databases, and it's ranged from FoxPro, EDX and Oracle, and some other databases. When I want to import data I usually use this tool for importing data from the other databases to the server. It is really good, and it's solved many problems for me because I can choose the source table, destination table, source field, and destination field. I can match these things, I can write some queries to do this and because of that, I use this tool. View full review »
Globalmark677
Platform Lead: Global Markets Data Analytics at Rand Merchant Bank
Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture. The interface is also very good. If users are familiar with Microsoft, then they'll be quite familiar with the interface. View full review »
Foundpa67
Founding Partner at Altdata Analytics
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 »
BIConsule1f7
BI Consultant at a tech services company with 201-500 employees
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 »
Brian Dandeneau
Lead Consultant at Applied Governance
The packaging and how it is organized is good for someone that really has never seen ETL before. View full review »
Prodown567
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. View full review »
Sasidhar Parupudi
Principle Consultant at Keyrus South Africa
The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions. Also, the use of the configuration on Azure. Our clients are basically secret sever based, so it works well there. View full review »
Kirill Slivchikov
Executive Director and Co-Founder at 7Spring Consult
The simplicity of the solution is great. The solution also offers excellent integration. View full review »
Igor Smirnov
Director at Netica d.o.o.
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 »
DevoSft67
Software Developer at a transportation company with 1,001-5,000 employees
It has good data integration and good processes. View full review »
reviewer789228
BI and Report Development Technician at a tech vendor with 201-500 employees
There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information. View full review »
Vincent Diallo-Nort
student
It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud. View full review »
Steve Seeber
Senior Director Business Intelligence with 201-500 employees
The most valuable features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT. View full review »
Ricardo_Silva
Big Data Architect, Integration Specialist with 51-200 employees
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 »
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration Tools. Updated: August 2019.
366,756 professionals have used our research since 2012.
Sign Up with Email