在 ssis 中增量加载的最佳方式 [英] Best way for incremental load in ssis

问题描述

我每天从源获取 600,000 行，我需要将它们转储到 SQL Server 目标中，这将是一个增量加载.

I am getting 600,000 rows daily from my source and I need to dump them into the SQL Server destination, which would be an incremental load.

现在，由于目标表的大小可能会每天增加，这将是增量加载的最佳方法.我脑子里只有几个选项:

Now, as the destination table size is likely to be increase day by day which would be the best approach for the incremental load. I have few options in my mind:

1. 查找任务

1. Lookup Task

合并连接

SCD

等等.

请建议我在增量加载中表现良好的最佳选择.

Please suggest me the best option which will perform well in incremental load.

推荐答案

看看 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.

这篇关于在 ssis 中增量加载的最佳方式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！