This SSIS package captures change logs for a table from SQL Server and pushes them to azure event hub
- SSISCDC -- Package to push initial data from table to event hub
- CDCIncrementalLoad -- Package for to push subsequent changes (Insert/Update/Delete) to event hub
#Assumptions
- CDC is enabled for the table
- Azure Event Hub is created in azure portal
#Useful Links
https://docs.microsoft.com/en-us/azure/event-hubs/event-hubs-create
https://www.mattmasson.com/2011/12/cdc-in-ssis-for-sql-server-2012-2/