 Hey guys, welcome to SSUNI Tech, so still decide and today we are going to see about the self-hosted integration runtime demo. So in the last videos we have seen about the integration runtime and types of integration runtime and we have seen about the SEO integration runtime and in the last video we have seen about the self-hosted IR. So if you haven't watched that video, so I would strongly recommend to watch that video before going forward. So in this video we will be going to see in the practical demo. So let's understand about our requirement. So here we are having two SQL Server, first is the Azure SQL that you can see here, second is the SQL Server that you can see here. So under the SQL Server we are having a table that you can see this employee data table and this employee data table is having around 162 rows and in your Azure SQL table we don't have any data. So our requirement is we want to load the data from the SQL Server that is on the environment to the Azure environment that you can see here and the table structure is same for both. So go to on the browser and we will try to create the pipeline. So here go to under the author tab and here let me try to create a new pipeline and let me call this pipeline as self-hosted data load. Now here we are required to use the copy data. So this copy data will load the data. Let me make this like this. Now this copy data we want to rename this. So this will copy data from SQL Server to Azure SQL. Now go to the source. So this time our source is on-prem environment that we have seen. So we have to create the data set. So before creating data set we are required to create the link service and under link service we have to use the self-hosted IR that we have created in the last load. So let me click on new and the source that is SQL Server that we can see here. Let me click on continue. Call this as SQL Server on-prem employee data and under the link service we are required to click on new and link service that should be SQL Server on-prem. Here we can see the integration runtime. So this time we are required to use this self-hosted IR that we had created in the last load. Now we can scroll down here. We need to specify the server name, database name and user ID and password. So here we can see the server name. So this is the server name. So go back to here and add the server name. Now what is the database name? So the database name is ssis underscore test. We can also verify from here. So this is your database. Now we need to add the username and password. The username is SA and password I am going to specify here. Now we can test the connection here. So test connection succeed. So that's great. Click on create. So this link service will be creating. Now here we have to select the table. So let me click on this and here the table that should be with the employee. So this is the table by which we want to load the data. Now let me click on OK. So this data set is created successfully and from this table we are going to load the data into the destination table and the destination table is in Azure SQL. So go to on the sync side and under the sync here we can see the sync database. So sync data set. So let me click on new and this is the Azure SQL. So let me search for Azure SQL click on continue. Let me try to call this as Azure SQL EMP. In the link service we have already created these but I am going to create a new one here. Let me call this as Azure SQL SSU. So this is already there. So let me call this as 01. Now here we are required to use the auto resolved IR because the destination is available in the Azure. Here we have to select the subscription. So this is our subscription we can select that. And after that we can add the server name. So let me click on this. So this is the server name and after that it is loading the database name. So the database name is SSU that's great. Now here we need to add the user ID and password. So let me try to add the user ID that is PVI and the password I am going to add here. Now we can test the connection here as well. So connection is succeed. Let me click on create. So it will create a new link service with the name of Azure SQL SSU 01. Here we need to select the table. So this is the table by which we want to load at it. Now click on OK. So this dataset will be created. Now we can go in the mapping and import the schema from here as our source table and the destination tables schemas are same. So it will map automatically that you can see here. Now we can publish this. So we can click on that and click on publish. Now we want to execute this. So we can click on debug. So it will take a little bit time to execute and we load the data from SQL server to Azure SQL. So as we can see in queue. So that is in progress now. So here we can see it got succeed in 25 seconds. Now go to in the SSMS and we'll try to refresh the table. So this table should have the data. So let me refresh with the control R. So here we can see the data is successfully loaded there and we can see 162 rows. So I hope guys you have better understanding how we can move the data from your SQL server on-prem environment to Azure SQL by using the self hosted IR. So thank you so much for watching this video. If you really like this video please subscribe our channel to get many more videos. Don't forget to press the bell icon to get the notification of our newly uploaded videos. See you in the next video.