 Hello friends, welcome to SSUritech, so see in this side and this is continuation of SSIH tutorial. So today we gonna discuss about record set destination by using edu enumerator. In our last video we have discussed about the edu enumerator if you haven't watched last video of this video series So I would strongly recommend to watch that video before going forward. So let's start with record set destination So what record set destination does? It doesn't save data into any external data sources like excel files, flat files or database tables And it saves data into memory in an object type variable So as we have discussed in our last video Once we have data in object type variable then by using for each loop edu enumerator, we can read data row by row So before going to ssgt, let's have a look of table So this is our table as we have used in our last video So it has total 4 columns and it has 13 rows So go to ssgt And here I would like to add one more package Then I wish to rename this package With record set destination And here I have to use dataflow task So I need to drag and drop Then double click on this dataflow task So here I want to save data from sql server table So we have to use ldb source And then we want to load data into an object type variable by using record set destination So I need to drag and drop record set destination So before configuring these two, let's create an object type variable So go to one variables And here I would like to add a variable And this is our obj and data type should be object Now close this and go to on dataflow Double click on this ldb source Here it would accept ldb connection manager So I need to click on new As I have already made the connection So I am going to use that one Click on OK Then I need to select the table So our table is for each loop employ adio And go to on columns It should have four columns And we want all the columns So I need to click on OK So we have done our source Now I need to configure our destination And double click on this And here as we can see Inside this custom properties We need to specify our object type variable which we have created So this is our object type variable Now go to our input And we want all the inputs Then go to our input output properties It looks good So basically what records our destination does It will pick the data from our input columns And it will load data into our object type variable Now click on OK Save this package And click on start So package executed successfully So it looks good So how we can check the data As we have discussed I need to use for each loop container And then connect with data flow task Now double click on this For each loop container Go to on collections Here I need to specify For each adio numerator Then we want to read data From this object type variable And go to on variable mappings And here I need to add a new variable And this is for employee ID So I can use EMP ID And data type should be integer So I want to use integer 32 And we need to specify a default value That is 0 Now click on OK As we can see index 0 So it will hold the data from employee ID Second employee name So index should be 1 Then salary index would be 2 For department ID index would be 3 So go to on ssdt And here I would like to add one more variable And this is for employee name So data type would be string It looks good Click on OK Next we need to create one more variable And this is for salary So this is our salary And so data type should be integer So I want to use integer 32 And default value would be 0 Now click on OK Our last column is department ID So add one more variable And this is for department ID And data type should be integer So I want to use integer 32 Default value would be 0 Now click on OK Again OK So we have configured our for each loop container Now we can execute and we can check So it looks good Stop this package And we want to check our output So we have to use script task inside this for each loop container Then double click on this script task In this read only variable We need to select all the variables which we have created So this is our department ID This is our employee ID And next our employee name And our last is employee salary Now click on OK I need to click on edit script So here we need to write code to check the output So I want to use messagebox.so Then we need to specify dts.varables Then .value.twistring And in this variables we need to specify our variable name So first I would like to use employee ID So we can use employee ID Here I want to concatenate with EMP ID So this is our EMP ID Then our second variable is EMP name So I want to concatenate with EMP name So this is our EMP name And again we need to specify dts.varables.value.twistring In this variable we need to specify variable name That is our user EMP name Then I need to use salary So this is our salary Then plus dts.varables.value.twistring In this variable I need to use variable name That is salary And our last variable is department ID So I want to use department ID dts.varables.value.twistring And here I need to specify our variable name That is our department ID So we have done Now we can save it and close Now click on OK Now save this package and execute So as we can see employee ID, employee name, salary and department For implied 2, 3, 4, 5 and it will get until employee ID 13 So package executed successfully Now we can stop this package I hope you have understand how we can use record set destination And we will cover real time use of record set destination When we will do case studies So thank you so much for watching this video If you 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 Thank you so much