CDC TASK GETTING ERROR

Question



when i am running the package i am getting this following error all time , can anyone explain me why it is?

---

Jay

Answer 1

It must be so it has been unable to tolerate such column name it indicated.

---

Arthur

MyBlog

Twitter

Answer 2

Yes this happened after i did my SQL 2014 CU5 update it was working fine before - Is there any bugs for CDC ?

---

Jay

Answer 3

Hi This is the answer:

For SSIS CDC Splitter component the simplest workaround could be to bridge execution of fn_cdc_get_<all|net>_changes_<tracking_instance> functions:

1. Rename upgraded fn_cdc_get_<all|net>_changes_<tracking_instance> to fn_cdc_get_<all|net>_changes_<tracking_instance>_original, e.g.
exec sp_rename @objname = N’cdc.fn_cdc_get_<all|net>_changes_<tracking_instance>’, @newname = N’fn_cdc_get_<all|net>_changes_<tracking_instance>_original’
2. Create new stored procedure with the name, how it was before renaming and call original function from it, along with returning all values plus the extra null as __$command_id, e.g.
create function [cdc].[fn_cdc_get_<all|net>_changes_<tracking_instance>] (@from_lsn binary(10), @to_lsn binary(10), @row_filter_option nvarchar(30))
returns table
return select *, null as __$command_id from [cdc].[fn_cdc_get_<all|net>_changes_<tracking_instance>_original](@from_lsn,@to_lsn,@row_filter_option)

---

Jay