Pubudu Dewagama

SQL Server Integration Service (SSIS) 2017 - Multicast Transformation

In this post I am going to explain how to use multicast tool in SQL Server integration Service. Mainly this component is use for redirect y...

SQL Server Integration Service (SSIS) 2017 - Multicast Transformation

Reviewed by Pubudu Dewagama on 6:59:00 PM Rating: 5

In this post I am going to show how to load Excel files data into SQL Server 2017 database table. First you have to create a your Excel so...

SQL Server Integration Service (SSIS) 2017 - Loading Excel data into SQL Server Table

Reviewed by Pubudu Dewagama on 2:05:00 AM Rating: 5

Pubudu Dewagama 11:29:00 PM

First go to Below link and download the Data tools for Visual Studio 2017 https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-da...

Install SQL Server Data tools for Visual Studio 2017

Reviewed by Pubudu Dewagama on 11:29:00 PM Rating: 5

Pubudu Dewagama 11:29:00 PM

First you have to download Oracle 19c set up file from the oracle site. Freely you can create account and download to your local drive. Li...

Install Oracle 12c on Windows 10

Reviewed by Pubudu Dewagama on 11:29:00 PM Rating: 5

Create a Power BI DashBoard. In this example I have used below Report Which I have developed using Sample dataset. Then you have to l...

Publish POWER BI Dashboard on Web Page using IIS Server

Reviewed by Pubudu Dewagama on 2:59:00 AM Rating: 5