 Hey guys, welcome to SSUniTech. So say this side and this is continuation of SSIH tutorial. So today we are going to discuss about CASA transformation. So what is CASA transformation and how we can use CASA transformation in real-time scenario. We will understand over here. So let's start with CASA transformation. So this is one of the data flow transformation. It uses memory CASA or file CASA as configured in CASA connection manager and push data from there. And this is very useful transformation while we are going to talk about performance improvement. So CASA transformation in SSIH is used to read the data from wide variety of sources such as flat file, excel sheets or adio dotted sources and save that data into a memory or in CASA file and extension of CASA file should be CAW file. We have a flat file source. So this is our flat file source. As we can see it has some record and we want to save that record in our memory and second we will store that record in CASA file. So go to on ssdt to implement the package. So here I want to add one more package. So right click on this. This is IS package. Then click on new SSIH package. Then I want to rename this package with CASA. So here we need to use a data flow task. So we can drag and drop this data flow task and then double click on this data flow task. Then it will directly need to data flow panel. Inside this data flow panel we need to configure our source transformation and destination. So our source is flat file source. So we can drag and drop this flat file source and then double click on this flat file source. Then so here we need to select our flat file connection manager as we don't have any connection manager right now. So I want to add new connection manager. So click on new. So as we can see flat file connection manager editor window has been opened. So here we can select our file. So we can browse and then go to on flat file and we can select our first file. Click on open. As we can see column names in the first row. So we are okay with it. It's a delimited file. Then go to on columns. So as we can see id, first name, middle name, last name and date oper. So we are getting the record as we expected. So click on okay. Then we can select this checkbox and go to on columns. So we want all the volume. Then click on okay. Our source has been done. Now we need to configure our transformation and our transformation is cassette transformation. So go to our other transformation and here we can see cassette transformation. So we can drag and drop this cassette transformation and then we can connect with source. Now double click on this cassette transformation. So here it required cassette connection manager. Hence we need to click on new. So here as we can see we have two options. First use file cassette if we have the file and we want to use that file. So we can select our use file cassette option. Otherwise go to on columns as we can see we are getting all the columns. So we don't want to get the data from file. We want to get the data from source which is our flat file source. So we are getting the data. So here we need to select any one column as index position. So I want to add id as the index position with one. Then click on okay. Go to on mapping. So we are getting the mapping and click on okay. Now our flat files data will be loaded on this cassette transformation and this cassette transformation uses the memory. So our flat file source data will be loaded in our memory. It will not going to load in any file. In our second scenario we need to use this and load that data in our cassette file. So I want to add one more data flow task. Then double click on this data flow task. Here again we need to configure our source transformation and destination. So our source is flat file source. So drag and drop this flat file source. Then double click on this flat file source. Here already we have made the flat file connection manager. So I want to use that one. Go to on columns. So we want to all the one click on okay. Now we need to configure our transformation. So transformation is cassette transformation. So we can drag and drop this cassette transformation and then connect with source. Then double click on this cassette transformation. Here we need to add one more cassette connection manager and this time we want to use file cassette. So here we need to specify the file. We can browse and go to inside this cassette transformation and here we can select our file. So we can set name with and we can say extension is caw file. So it will generate a caw file once we gonna run this package. Click on open. Go to on columns. So we want all the column. So again here we need to set the index position. So I gonna add index position with id so one then click on okay. Go to on mapping. So mapping succeed. Again click on okay. So this time I wanna run this package and go to our folder. So this is our cassette transformation as we can see this folder is empty right now. So I wanna run this package. Once I run this package then we can see five rows has been moved to our caw file. We can stop this package and go to our folder. As you can see twice caw file has been generated. So now we can open this file in notepad. So I wanna open this file in notepad plus plus. So as we can see five rows first is our column names. Then we have our data. So what is the real time use of cassette transformation? So by default lookup transformation in SSIS is uses polyadb connection manager for lookup refresh table. We can use other sources also like flat file, excel source or any another source except polyadb source. But we cannot use that source directly. So we have to use that sources indirectly via cassette transformation. So we use cassette transformation to save the refresh table in caw format and then perform lookup transformation using the cassette connection manager. Like we have two flat files and we want to compare our first file with our second file. Then we can compare between these files by using lookup transformation. So if we want to use cassette data in multiple packages then we can store cassette data in caw file then it can be used in other packages as well. So we will implement this package while we want to discuss about lookup transformation. So thank you so much for watching this video. If you like this video please subscribe our channel to get many more videos and press the bell icon to get the notification of our newly uploaded videos. Thank you so much.