Head, Development Chapter (DevOps) at First Bank of Nigeria Ltd.
Real User
Top 5
2024-03-01T11:49:00Z
Mar 1, 2024
The ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs.
Admin at IEC (Electoral Commission of South Africa)
Real User
2022-06-07T14:58:00Z
Jun 7, 2022
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.
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.
Senior Analyst at a tech services company with 1,001-5,000 employees
MSP
2021-12-29T11:01:00Z
Dec 29, 2021
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.
Data Engineer at a tech services company with 11-50 employees
Real User
2021-05-19T19:43:47Z
May 19, 2021
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.
BI Consultant at a tech services company with 201-500 employees
Consultant
2019-07-31T05:52:00Z
Jul 31, 2019
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.
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.
There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information.
Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools.
SSIS is a versatile tool for data integration tasks like ETL processes, data migration, and real-time data processing. Users appreciate its ease of use, data transformation tools, scheduling capabilities, and extensive connectivity options. It enhances productivity and efficiency within organizations by streamlining data-related processes and improving data quality and consistency.
The product's deployment phase is easy.
The ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs.
I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows.
The solution is easy to use and developer friendly.
We can connect with multiple data sources easily using an external connector in SSIS.
SSIS is easy to use.
The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work.
The most important features are it works well and provides self-service BI.
It is easy to set up the product.
SSIS' most valuable feature is its reporting services.
The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task.
It's saved time using visualization descriptions.
We like that this solution includes a developer edition, free of charge, to allow for training.
SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code.
Like most Microsoft products, SSIS is user-friendly and easy to use.
The most valuable features of SSIS are that it works with the query language and it can import data from different sources.
The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle.
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.
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 something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better.
The performance and stability are good.
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.
It's a competent product.
The technical support is very good.
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.
The interface is very user-friendly.
The script component is very powerful, things that you cannot normally do, is feasible through C#.
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.
The most valuable features of this solution are the fast insert and fuzzy logic matching.
This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language.
It has good data integration and good processes.
The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great.
The simplicity of the solution is great. The solution also offers excellent integration.
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.
The initial setup of this solution is very straightforward.
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.
With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server.
The setup is straightforward. It's very easy to install.
It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs.
I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import.
Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture.
The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions.
There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information.
It's already very user-friendly and has a good dashboard.
The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT.
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.
Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools.