Multicast Transformation in SSIS: Simplify Export of Data to Excel and SQL Server Simultaneously (with Example)

Total: 2 Average: 5

In professional work scenarios, we often need to load data from one report to several destinations, such as Excel files and SQL databases. One of the ways to accomplish this is using an Multicast Transformation in SSIS which accepts the data input and splits it into several outputs, creating logical data copies. As a result, you get several result copies to apply them to different purposes.

The current article clarifies the steps of gathering information, identifying problems, and designing the solution initial phase. Note that the material is meant for users with some backgrounds. It is desirable to be familiar with the SQL Server work, T-SQL scripting, and dedicated tools. You may refer to the following articles for details:

CodingSight - Sending Report Data to Excel and SQL Database using Multicast Transformation in SSIS Packages
Read More

How to Create the Date Table in Power BI

Total: 1 Average: 5

The time intelligence functions for the data models or databases running behind a Power BI report are really helpful. To make the most use of them, we can create a Date table on the Power BI desktop.

This article focuses on the steps required to perform this task. Also, it highlights the importance of having such Date tables for authoring the Power business intelligence (BI) reports to work as the output of a fully functional data warehouse BI solution.

CodingSight - Date Table in Power BI
Read More

SQL Server Business Intelligence (BI) – Traditional Tools and Technologies

Total: 1 Average: 5

If Business Intelligence (BI) is in your focus, you need two things to be a success. They are the knowledge and tools. If you target the SQL Server BI, you can benefit from the tools and technologies offered by Microsoft for this case particularly.

The current article highlights these tools and technologies. We are going to explore how they work to design Microsoft-based BI solutions and clarify why it is so crucial to use the using proven tools for serving the BI needs of an organization.

Read More

SQL Server Business Intelligence (BI) – Basic Understanding

Total: 2 Average: 5

In this article, we are going to clarify the fundamentals of Business Intelligence (BI) concepts with their benefits from the data utilization point of view, and explore the SQL Server-focused Business Intelligence solutions by practical examples and illustrations.

Before we discuss the particular issues related to SQL Server, let’s define the basic ideas of business intelligence.

Read More

Learn to Multicast Data Using SSIS Packages

Total: 1 Average: 5

This article describes configuring the job of multicasting data with the help of SSIS (SQL Server Integration Services) Packages. Also, it highlights the importance of Multicast Transformation in SSIS for sending data to multiple destinations as per requirement.

Additionally, we are going to explain the benefits of multicasting data and provide some professional tips.

Read More