 Hello, welcome to SSUnitech, so still decide and this is continuation of SSIS tutorial. So today we gonna discuss about change data capture. So before going forward, if you haven't watched part 58 of this video series. So I would strongly recommend to watch that video where you can understand about the incremental load and why incremental loads are required. So let's start with change data capture. So this is a technique to deal with incremental load as I have told you. Next is CDC was introduced in SQL Server 2008 and it tracks inserts, update and delete operations in SQL Server table. And it's very good in performance than other techniques like triggers. And we have discussed the last few videos of this video series how we can deal with incremental load by using lookup transformation. When CDC is enabled, the changes are written into a table and can be accessed by using system store procedures and we cannot implement CDC in system databases. So before using change data capture, we need to enable change data capture in our database level as well as in table level where we want to implement change data capture. So as we can see first we need to enable in database then at table level. So in table level we need to enable only on source table. Like we have a source table and we want to load data from that source table to our destination table. There is no need to enable change data capture in destination table. We need to enable change data capture only in source table. So go to our SQL Server management studio and try to enable CDC. So here as you can see as I have already written the query. So our first query will check CDC is enabled in our database or not. So we can execute. This is our simple system view, sys.databases. So it will return all the databases and I have applied filter on name. So it will return only one row. So as we can see if CDC enabled is 0. It means CDC is not enabled at this database. So first I would like to execute this query to enable CDC at database level. So this is our simple system store procedure and we need to execute sys.sp.cdc.enable.db. So I am going to execute this query. So command completed successfully. Now we can execute our selected statement and check is CDC enabled or not. So as we can see we are getting 1. It means CDC is enabled at the database level. Now we need to enable CDC at the table level. So that's why I would like to execute our second selected statement. And here we can check is tracked by CDC. So we can see we are having 0. So this is our employee source table. So we want to implement CDC on this employee source table and we want to load data from this employee source table to employee destination. So this is our second query. So once we will execute our second query so it will enable CDC at employee source table. It accept first parameter as schema name then table name then roll name then supports net changes. So I would like to execute this query. So as we can see we are getting an error. Like we don't have any primary key in our table. That's why support net changes should be 0. Now I need to execute our query. So command completed successfully and I would like to select sys.tables then we need to check CDC is enabled or not. So as we can see in employee source table we are having 1. It means CDC is enabled in employee source table. Now we will able to capture the change data capture because CDC is enabled at database level as well as at table level. So I hope you have understood how we can enable change data capture at database level and at table level. So 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.