SSIS Reviews

I work with all of them as a Microsoft Certified Trainer, particularly around the Business Intelligence SQL space. I tend to do quite a bit of work around the SSAS space, SSIS, SSRS, and integrating that into a lot of SharePoint and other spaces.

The challenge is building from the KPIs. Being able to put your KPIs in place starting with understanding a board of directors and their needs, and being able to build the KPIs for an organization from that level is important. Then being able to deliver those on a dashboard, such as Power BI, or something else, also matters. Additionally, being able to build cubes that allow for rapid analysis over a long period of time is crucial. The one thing which is missing often enough is building out your data warehouse with your data models, so helping to build the data models is very important. I appreciate how it handles large data in your warehouse.

Stability is rated at 10. One other important aspect I appreciate is that SSAS is included in the base installation of SQL Server. Obviously, it requires installation, but it is readily available, which is a major strength. It's all about setting it up, configuring it, and then using it. If there are additional costs associated with it or separating it as a second product, that would be a disadvantage.

The area of improvement is really in education. Microsoft is trying to push everything as a Power BI solution or trying to get people to solve the problems which are solved with SSAS in another space in Power BI, or in Power Pivot, is not enough. There's not enough marketing, conversation, and support around that space. As a result, we end up with people not understanding that you need to build your models correctly, and then they try to model everything inside of Power BI, or another visualization tool, without first building the data model.

That leads people to consider alternate solutions because SAP and others argue that their whole thing is in memory, and they disseminate misleading information. Additionally, what would be very helpful is local user group developments, so getting people around the table and teaching them how to use it. That is the biggest problem; it's not the technology itself. The challenge lies in Microsoft withdrawing a lot of the qualifications and watering down its emphasis, leading to a perception that this is supposed to be an elite product.

We use the solution for ETL. It helps to move data from one server to another and translate it in the middle. 

I like that this solution is very scalable, accommodating large datasets and various types of servers. It integrates with most common database servers and allows for customization through coding, including complex scripts. Compared to Alteryx Designer, SSIS offers more customization. Its data cleaning capabilities are highly accurate because we can run tests as data is loaded, ensuring it meets all requirements before reaching the final destination. The ability to write custom SQL and C# code within SSIS packages is its greatest feature. 

I use SSIS for data loading ETL processes. I am responsible for the EDW layer and get new data from other data sources into the EDW via SSIS.

SSIS has too many bugs. Sometimes it works, sometimes it doesn't. I try to use a package, and it won't work on my computer, but it will on another user's computer. If I could rely on the program more, it would be better.

We use SSIS for data extraction, transformation, and loading processes. This includes extracting data from various sources like Oracle and SQL Server, and then transforming it for use in reporting tools like Power BI dashboards. While we haven't directly migrated data between databases using SSIS, we have used it extensively for ETL tasks, such as extracting data for analysis and reporting purposes.

Presently, we have decommissioned the solution. Earlier, we used SSIS with the SQL Server.

The most valuable feature of the solution is performance. It works by connecting to the SQL Server.

In my experience with SSIS, I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows. We often use templates, inheriting and embedding scales in SSAS to streamline our processes.

In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse. After resolving these issues and conducting load balancing tests, we proceeded with the SSIS upgrade, anticipating potential complications. 

I use the company's solution to build dashboards and back-end data integration with Microsoft SQL Server and Power BI.

The most valuable features of the solution stem from the convenience it offers, along with the ability to refresh data.