看看 Andy Leonard 的优秀Stairway to集成服务系列或 Todd McDermid 的关于如何使用免费的SSIS Dimension Merge SCD 组件的视频比我在此框中列举的方法要好得多.

Look at Andy Leonard's excellent Stairway to Integration Services series or Todd McDermid's videos on how to use the free SSIS Dimension Merge SCD component Both will address how to do it right far better than I could enumerate in this box.