Hi
I have one query related to SSIS. We have views which may contain more than 1 table. As we are applying CDC on a table, is there any way to apply CDC on View.
Regards
Loganathan
Technology Tips and News
Hi
I have one query related to SSIS. We have views which may contain more than 1 table. As we are applying CDC on a table, is there any way to apply CDC on View.
Regards
Loganathan
Hi Loganathan,
Just as Olaf said, we cannot enable CDC on a view, it must be enabled at the table level, on a table-by-table basis.
The change data capture process retrieves this information from the transaction log and writes it to change tables that are accessed by using a set of functions. A standard view is only a logical abstraction of physical tables and does not provide any actual data storage to change. So we cannot enable CDC on a view.
For more information about Change Data Capture, please see:
http://bradmcgehee.com/2010/04/21/an-introduction-to-sql-server-2008-change-data-capture/
Thanks,
Katherine Xiong