 Hey guys, welcome to SSUnitag, so see this side and this is continuation of SSIS tutorial. So today we are going to see about the package configuration. So what is the package configuration and when we can use that. So basically package configurations are a flexible method of dynamically configuring a package at runtime. This gives you a high degree of flexibility in the execution of the SSIS package. So by enabling you can design the package to the runtime in different environments without having to modify the package file itself. So when a package is written not all operations parameter may be known such as the location of the file or the value of the variable. So what it means? So it's basically if we are going to design a package and we want to move the package from development environment to core environment. So without making any changes on your file, we want to make the change only inside the configuration file. So all the values for the connection string, the variable values, so all the values will be available inside the configuration file. So by where we can use that go to on the SSMS. So here we are having these two tables. First is the EMP data destination where table and this is EMP data and where table. So here simply we want to load the data from this and where table to this where table. So let me go inside the SSGT and here this is our SSGT. Let me use the data pro task. So we can drag and drop this data pro task here. Double click on that and here let me go in the source. So our source which is the SQL server table. So we can use the OLDB source and here let me double click on that. Click on new. Here let me click on new again. This is our server name. So we can copy this, cancel it, go back to here, paste it there. Inside the database we can select SSIS test. Test connection succeed. Click on okay, again okay, again okay. Inside the table as I told you we can select the EMP data and where table. In the columns we want all the column. Let me click on okay. Now we want to load the data into the SQL server table again. So the destination that should be OLDB destination. But here as I told you so here in the source table the columns those are containing NWARECARE data type. As you can see in the name that is NWARECARE and in the destination we have only WARECARE data type. So we have to use the data conversion. So let me use the data conversion in between source and destination and double click on that and we want to modify this. So here that should be a string data type. Let me click on okay and connect with the destination. Double click on that. So the destination table that is EMP data destination where in the mapping instead of name that should be copy of name. Let me click on okay. So we have done with this package. If we can execute this package then data should be loaded in the table. Let me check the count. So let me execute this package. So here it is executed successfully. Let me stop this package and here so it is 108. Data is inserted successfully. Now here we want to enable the configuration. So for that we need to go inside the control float right click on that. Then you can see the option for the package configurations. Let me click on that. So here we need to enable the package configurations. Then we can add. So here it will open this package configuration wizard. Let me click on next. So here we can see the type. So total we are having five types of the configurations. We will check one by one. In this video we are going to see about the sequence over type. So let me click on that. So on which DB we want to create the table where the configurations data will be available. So I am going to use the same. So let me click on okay. In the table. So here we don't have any table or we can use this SSIS configuration table. So let me use this SSIS configuration table. And in the filter type we can select this one from this program. So that's it. This is the only thing that you need to do. Then you can click on next. So it is saying the table SSIS configuration already contain the configuration value with the one. So whether we want to use existing or override. So let me write that. Then we can click on next. Here we need to select on which property we want to keep inside the configuration. So as you can see we are having a lot of properties. So first property that I can see the connection string. So inside the connection manager inside the properties we can see the connection string. So we want to keep this connection string there. Then if you want to also keep this initial catalog value that should be there. After that you can see the properties of this checkpoint and all these. So if you want to keep then you can also select this checkbox. Let me click on next. Then click on finish. So it is added. Let me now we can go inside the SQL server. And here inside the SSIS test we should have a table that is SSIS configuration. So let me go inside the table and here let me try to find out the SSIS configuration table. So this is the SSIS configuration. Let me select this table. So as of now we can see we are having these two. So first is the configuration value for the initial catalog as I told you and second for the connection string. So these two values are here. Now go to on the SSDT package and execute it. So it should be executed successfully. Let me stop this package and here let me go and let me check the value. So data is inserted successfully on the destination and here as we can see the values are this. So if you want to make the change on this. So we can easily make the change. So let me copy this connection string and paste it here. Now let me go and we want to load this data in second instance of SQL server. So which is containing SQL 2k17. So instead of this we want to have this slash SQL 2k17. So this will be the connection string. So let me copy this and here let me go on the SSIS test. Right click on that, new query and let me copy this and check the value. So value 79 and 26. Now I want to update this. So update on SSIS configuration set configuration value that should be this value where this package path. So let me filter for this package path that should be this value. Now let me execute this. So one row affected. So now we are going to refer this server. And the count that you could see 79. Let me try to execute this package now. So click on start. So it got executed. Let me stop this go back to here and now we can see it is having 105. So package we did not make any change. We only updated the configuration value inside the table and it is going to refer the another instead of SQL server. So I hope guys you have understand how you can set up the configuration on your package. In the next video we will see how we can set up the configuration inside the XML and the other options. 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.