The other day I was working on an SSIS implementation that was utilizing Change Data Capture (CDC) to identify the source data that needed to be transformed into the destination. This is the first time that I had used CDC other than a quick demo and I was grateful to have Whitney’s help with understanding [...]
Traditionally I have used SSIS for OLTP data movements, however lately I’ve been loading a Data Warehouse which has slightly different requirements. I just wanted to drop a quick note to highlight the great resources that already exist out there (and thanks to Dan English for pointing me to most of them). These have been [...]