 Hello friends welcome to SSUnitech, so still decide and this is continuation of SSIS tutorial. So today we gonna discuss about parallelism. So what is parallelism? So it is a great technique to improve the performance of our data integration operations and it supports parallel execution of practice, task and transformations. So when we talk about parallel execution then maximum concurrent executable property comes into the picture and default value of this property is minus 1 that means maximum number of task can be executed at a single time. As Microsoft says when we set n plus 2 value of this property then we will get the best performance and n is the number of process nodes. So how we can calculate the number of process nodes? So we need to go to on SSMS then right click on this server name goto on properties then goto on processes and here as we can see all so we need to expand then again expand. So here as we can see we are having four nodes. So once we will set 4 plus 2 it means 6 then we will get the best performance and performance will also depend on the hardware specifications as well. So here in this case study as we can see we are having two execute SQL tasks first it will capture start time of this package and in our last and it will capture end time of this package and inside this package we need to use 10 execute SQL tasks where we will insert record in our table. So goto on ssdt to implement the package so here I wish to add one more package then I want to rename this package I need to drag and drop execute SQL tasks so it will capture start time of this package so double click on this here we need to make our connection manager so click on new connections as I have already made the connection so I gonna use that one click on OK then in SQL statement I have already typed the query so I gonna copy that one and paste it here. So this is our query let's have a look of this table so this is our table so as we can see for ID 1 we are having four sequence and start time is null and end time is null so it will update start time and end time once our package will be completed successfully so I gonna copy this update statement and paste in execute SQL tasks now click on OK again OK now I need to drag and drop one more execute SQL tasks and it will capture end time of the package so I need to use that connection and so goto on ssms and I need to copy this update statement and paste in execute SQL tasks now I need to click on OK again OK so we have captured our start time and end time now I gonna use a sequence container then I need to connect start with sequence container and sequence container with connect with end and inside this sequence container I gonna use execute SQL tasks double click on this and need to make the connection then here I want to write a query to insert record in a table so I have already write the query so this is our query by which we will insert 10000 record in a table so I gonna copy that one and goto on ssdt and paste it here and click on OK again OK so we have done our first now I need to copy this and paste over here and this is our second now we can copy and paste third fourth fifth sixth seventh so here we are having 10 executes SQL tasks that will be executed to insert record in our table so I gonna connect these one by one then second then third then fourth so here I have connected one by one now I gonna execute this package and to check our start time and end time so once we click on start then as we can see our first execute SQL task will be completed then move to second one second will be completed move to third one third will be completed move to fourth then fifth and it will take until our last execute SQL task will not be completed so as we can see package has been executed successfully I gonna stop this package and goto on ssms and here we can refresh this table and we can check so start time and end time has been captured so this package was started from 21 25 29 and it's completed 21 26 0 8 now move to ssdt and design this package to run parallel execution so I need to remove these connections now right click on this package and goto on properties so here we have a property with maximum concurrent executable so I gonna change with five so five execute SQL task will be executed at once once these five will be completed then next five will be executed so before run this package I need to change our update statement and this time I would like to run for ID to because this is for parallel execution now click on and and here I would like to change for ID to click on okay okay we can save and click on start so as we can see five execute SQL task is going to executed at once so package executed successfully now I can stop this package and goto on ssms and here I can refresh this table so we can check 21 28 54 is our start time and 28 21 29 is our end time so this package is executed very early previously when we executed our package with sequence then it was taking a lot of time but once we design this package for the parallel execution then it's going to execute early 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