How to Extract and Load

I am writing simple steps, how we can Extract and Load data from a Database to a Data warehouse.

Firstly, we need to install Visual Studio. I have installed Visual Studio 2019.

After installing visual studio, we need to install Extensions. 

We can see in the above image that I have installed SSIS SSAS and SSRS extensions.

Now we need to create a new project,,,

Name your project and define location and create it.

We will see a window or interface like below.. now this is the place where we create a connection to data source, then we have a package or pipeline (ETL Package)
This control flow is a Pipeline.

Drag the data flow task to the design area.

Now, double click on it and we will get to the next tab Data Flow. Here click on the Source Assistant .. > SQL Server …New > Server Name .. Database Name... Test the connection

Now we will do the same steps for Destination Assistant (to load data in data warehouse)

but this time select the destination database, where we will load our data. see image below

Now we have source and destination on the data flow.. 

Now double click on the source..

Here we will select the table that we want to extract from source destination.. I have selected table rakesh and in the destination i have selected new and you can name the table rakesh, and we can do mapping to the column level to match the column from source to the destination. check below image.

Now, we will run the ETL package to load the data. The job has run successfully, and 5 rows has loaded to the destination database.

We can query the destination database to check or verify the result.