  contributor  newer 美味  ubiquit C గి 관심ద్థినీచ్ ఆంియాజైప్మ్చృ చ�을ూ�半, . , so we need to trainers while using the  spiders. నాెఔ౏, uwso use to remove the hoping call from the source data ఇరిఫి నిసితిఒరం, నానిమౄలివఋకికికా� guided if it found duplicates then remove any of them and get unique values like if we have four columns in our table like id name, date of birth and gender and we are going to sort on the block of id and in id column we have the duplicate record and rest of the column we don't have the duplicate values so it will look only id column and if duplicate value will be found then one rule will be deleted and unique value will be available so we have a sequence of our table for our testing purpose so let's have a look of that table so this is our table with the name of sort as we can see it has only one column which is named and it contains the values so in our first row in our last row we can see it seems to be duplicate so one value should be deleted so how we can achieve this let's move to ssdt to create our package so right click on this and create a new package and then I want to rename with sort then we need to drag and drop data flow task double click on this and here we need to select our source so our source is well adb source so we can drag and drop well adb source and then we need to configure here we need to select our connection manager click on new as we have already made the connection so I am going to use that one click on okay here we need to select the table so our table is sort as we can see this is our table got one columns we have only one column which is named so we are okay with it click on okay so we have done our source part now I am going to use the sort transformation so this is our sort transformation we can drag and drop this and connect with the source now we need to click on sort once we click on sort then we can see available input columns so we can select our column and we want to order by with that column in ascending order or descending order according to our requirement we can set the sort type here we have option for remove rows with the duplicate sort values once we select this checkbox then our duplicate value will be removed now click on okay as we can see in our input we have a duplicate value and that value will be removed I am not going to load this data into any destination I am going to display this data by using multicast so we can drag and drop this multicast then we can connect to the sort now we can enable our data viewer then we can execute our package so here we can see 123 we are getting only once so duplicate value has been removed next is sorting with the string data SQL server sort and SSIS sort treats as a differently because SQL server uses the case in sensitive and SSIS uses the case sensitive so as we can see in our SSIS sort and you know SQL server sort so in our first room we have the same data in our second row and third row we are getting the in our fifth room and your sixth room so we have the different values in case of SSIS sort and SQL server sort let's have a look in SSDT and SQL server so here as we can execute our package now I am going to copy this data so we can open Excel and paste that data now go to SQL server and I am going to use order by 1 and copy this data and paste that data so as we have removed the duplicate value so we can delete our 123 and here we can see so this is our SSIS sort and this is our SQL server sort so we are getting the different values in case of fourth row fifth row in case of seventh row eighth and ninth row because SQL server uses case in sensitive and SSIS uses case sensitive so how we can remove this different behavior so once we use the case sensitive in our SQL server then that will be removed so go to our SQL server and paste that query here we can execute and copy the data and go to on Excel now I am going to paste that data and delete one row as we can see in our SSIS sort and SQL server sort both are treated as a similar so you need to remember while using sorting with the string data types so thank you so much for watching this video if you like this video please subscribe our channel to get many more videos thank you so much