 Hello, welcome to SSUnitech. So see in this side and this is continuation of SSIS tutorial. So today we gonna discuss about multicast and what are the difference between multicast and conditional split. In many interviews, you can see interviewer wants to ask about the differences between multicast and conditional split. So we will cover this part in this video. If you haven't watched part 13 of this video series, so I strongly recommend to watch that video where you can understand about the conditional split. So let's start with multicast. So what is multicast? So multicast transformation in SSIS is used to distribute every input rows to every rows in one or multiple outputs. If you have a scenario by which you want to load the data from any source to multiple destinations and data would be the same as we are getting from input then you can use the multicast. In our scenario as you can see we have a table and we want to load data from that table to multiple flat files. So this is our table as you can see it has 20 rows. So we want to load all these 20 rows in multiple files. So here as you can see we have three folders file 1, file 2 and file 3. So we want to generate 3 files and that file will contain all the data which is available in this table. So how we can achieve it? Let's move to ssdt. So I am going to create a new package. So right click on this and create a new package then rename this package with multicast. So this is multicast. Now I am going to drag and drop data flow task because we are dealing with movement of data. Then double click on this data flow task. So here we need to configure our source, transformation and destination. So our source is OLEDB source because we want to get the data from sequence over table. So here we need to configure our OLEDB source. So double click on this. It will ask for OLEDB connection manager. So click on new. We have already made the connection. So I am going to delete that connection and create a new one. So once we click on new then connection manager editor window will be open and it will ask for server name. So we need to select the server. So this is our server name and then log on to server. I am going to use Windows authentication. So there is no need to enter the user ID and password. So here we need to select the database name. So this is our database name. We can test our connection. Connection succeed. Click on okay. Then again okay. So we have done our connection manager. Now we need to select the table. So this is our table. Go to one columns. We want all the columns then click on okay. So we have done our source path. Now we need to use multicast. So go to inside this common and here we have multicast. So we need to drag and drop this multicast. Now connect with source and then we want load the data into three different files. So we need to select the flat file destination. So flat file one, flat file two and flat file three. So in our flat file one, we need to connect with multicast then two and then three as well. Now I am going to make the connection for flat file destination one. It will ask for flat file connection manager. So we need to click on new. Then we need to select the flat file format. I am going to generate the file with the delimited format. Now click on okay. So here we need to select the file name. We can browse. So here we can see we have three folders. So I am going to generate the file inside this file one folder. This is for one. So click one then open. Column names in the first row. We need to select this checkbox. Then move to columns. We are okay with it. Then click on okay. Now go to on mapping. So mapping succeed. Now click on okay. Now we need to configure our second file. Now click on this. Click on new. Then again delimited file. Here we need to select the file. And this time I am going to load the file inside this file two folder. Click on open. Column names in the first data row. Then move to columns. So we are okay with it. Click on okay. Go to on mapping. Mapping succeed. Now click on okay. Now we need to configure our third file. So double click on this. Again click on new. We want to generate the delimited file. So we are okay. Now we need to select the file. And this time I am going to load the file inside this file three folder. Three then open. Select this checkbox. Go to on columns. Okay. Go to on mapping. Mapping succeed. Now click on okay. So we have done our package. So initially we don't have any file in this folder. If we can open then we can check it. We don't have any file. So now I am going to execute our package. Once we have executed our package then we can see 20 rows, 20 rows and 20 rows. And in our input we can see 20 rows. So 20 rows we are getting from our input and all the 20 rows have been moved to in our file. Now we can stop our package and go to our folder. In file one as we can see we have the file and it contains 20 rows. Now move to our second folder. Then again we have 20 rows. Then move to our third and last folder. As we can see we are getting 20 rows. So as we can see we have redirect all the rows which we are getting from our input to all the outputs. Then what are the difference between multicast and conditional split? And this is very important. So first is multicast. So replicate source data to multiple destinations so that different logic can be implemented to the same source data. In case of conditional split, distributed the source data into multiple destinations based on the condition. In our multicast we cannot apply any condition. But in case of conditional split we can implement the condition. In case of multicast redirect all the rows to every output. But in case of conditional split direct row to single output. In case of multicast it doesn't have any error output. But in case of conditional split we have an error output. In case of multicast we cannot apply any expressions because we can't use any condition. Go to our package then double click on this multicast. We don't have any option by which we can apply any expression or condition. But in case of conditional split we can specify our conditions by which we can apply our expressions. So in case of multicast it doesn't have any default output. But in case of conditional split it provides default output so that if rows doesn't match with expression then it redirect to default output as we have discussed in our last video. So these are the differences between multicast and conditional split. And you need to remember all these differences so that you can explain in your interviews. So thank you so much for watching this video. If you like this video please subscribe our channel to get many more videos.