 Hello, welcome to SSUnitech. So, see this side. And this is continuation of SSIS tutorial. So today we gonna discuss about what is the row count transformation and how we can use it. In our last video we have discussed about the project parameter and package level parameters. And how we can use it inside the dataflow task. So today we gonna discuss about row count. If you haven't watched previous video of this video series. So I would strongly recommend to watch that video. So let's start with the row count. So what is row count? So row count transformation is used to count the rows as they pass through dataflow task and stores final count into a variable. Basically row count transformation is used for the auditing purpose. So here as we can see, first of all we have to use a dataflow task and inside dataflow task we are going to get the values from flat file source. And then we have to use a row count transformation where we can count the number of rows that is going to pass from flat file source. And we will store that count into a variable. And then by using script task we will see that count. So let's start with this case study. So go to on ssgd and here I am going to create one more package and rename this package with row count. So this is our row count. And as we have discussed, we need to use a dataflow task. So this is our dataflow task. Double click on this. It will directly move to dataflow panel. So inside dataflow panel, we are going to get the values from flat file. So our source is flat file. So we can drag and drop this flat file source and need to make the connection for this flat file source. Double click on this. Then it will ask for flat file connection manager. Then click on me. So it will open flat file connection manager editor window. Here we need to select the file. We can browse and we can select our file. This is our file. Click on open and go to one columns. As we can see we are getting the value. So click on OK. Then click on OK. So we have done our source part. Now we need to use transformation. So row count transformation is a label inside the common. Here we can see row count. So we can drag and drop row count and we can map. Now we need to declare a variable where we will store the value for this count. Go to one variable. Add a variable. Here we need to specify count and value should be integer. So we have done. Go ahead and now double click on this row count. Then we can see it will ask for variable. From which variable we want to store the values. So we want to store in this variable. Click on OK. So we have done our row count transformation. Now we need to check the value. Then go to on control flow panel. So inside this control flow panel we have to use script task. By using we can see the output. Now map and double click on this script task. Then it will ask for scripting language. I am going to use sysart and we have option for bb as well. Here we have two options. First is read only variable. Second is read and write only variables. So I am going to use read only variable. Click on this. Then we can select our user count. Then click on OK. Then we need to click on this edit script. Once we will click then it will take few seconds. Then it will open a script. So inside this script we have main block. So inside this main we need to specify our code. So we can use message box dot so then dts dot variables inside the bracket. We need to specify our variable dot value dot to string. So we have done our code and this code will be available on the description of this video. So you can copy if you need. Then close it. Click on OK. So now I am going to execute this package. So as we can see 32. So if we can see our flat file then it should have 32 rows. So here we can see. So we have total 32 rows. So these 32 rows are going to display by row count transformation. So I hope you have understand how we can use the row count transformation. How we can use in real time scenario. Once we will cover auditing of the package then we can understand the real time use of row count. So thank you so much for watching this video. If you like this video please subscribe our channel to get many more videos.