2 Updates __$operation == 4 3 Deletes __$operation == 1 OLE DB Command Data Mart Deletes The Delete flow is directed to the OLE DB Command Data Mart Deletes. The following command is used to apply the changes within this flow to the destination: delete from CDCSample.WorkOrder where WorkOrderID = ? The command requires a column from the result set in to successfully apply the delete. This is the primary key columns for the table. The delete command above is for the child package processing changes to the WorkOrder table, which has a single primary key column WorkOrderID. The mapping of result set columns to command parameters can be seen in the following diagram: Figure 6: Result Set Mapping for Deletes OLE DB Command Data Mart Updates The Update flow is directed to the OLE DB Command Data Mart Updates. The following command is used to apply the changes within this flow to the destination: update CDCSample.WorkOrder set ProductID = ?, OrderQty = ?, ScrappedQty = ?, StartDate = ?, EndDate = ?, DueDate = ?, ScrapReasonID = ?, ModifiedDate = ? where WorkOrderID = ? This command requires all of the source columns from the result set in order to successfully apply the update. The mapping of result set columns to command parameters can be seen in the following diagram: Figure 7: Result Set Mapping for Updates
2 Updates __$operation == 4 3 Deletes __$operation == 1 OLE DB Command Data Mart Deletes The Delete flow is directed to the OLE DB Command Data Mart Deletes. The following command is used to apply the changes within this flow to the destination: delete from CDCSample.WorkOrder where WorkOrderID = ? The command requires a column from the result set in to successfully apply the delete. This is the primary key columns for the table. The delete command above is for the child package processing changes to the WorkOrder table, which has a single primary key column WorkOrderID. The mapping of result set columns to command parameters can be seen in the following diagram: Figure 6: Result Set Mapping for Deletes OLE DB Command Data Mart Updates The Update flow is directed to the OLE DB Command Data Mart Updates. The following command is used to apply the changes within this flow to the destination: update CDCSample.WorkOrder set ProductID = ?, OrderQty = ?, ScrappedQty = ?, StartDate = ?, EndDate = ?, DueDate = ?, ScrapReasonID = ?, ModifiedDate = ? where WorkOrderID = ? This command requires all of the source columns from the result set in order to successfully apply the update. The mapping of result set columns to command parameters can be seen in the following diagram: Figure 7: Result Set Mapping for Updates
CDCSSISLSN.docx