Hi have two SSIS packages..one for the initial load and other for the incremental load.I did the following steps.
1. I run the initial load.
2. Modify data to the CDC enable table.
3. I check in SQL Agent that changes were picked by CDC. I also waited for 30 minutes.
4. I run the incremental load - nothing happens.
5. I run the incremental load one more time - this time changes are processed.
Always when i run the incremental load it doesn't work for the first time.If i run it immediately for the second time.It works!!!!
Can anyone please help regarding this!!
Thanks,
Rahul Abhinav