有两种方法可以解决此问题.最简单的方法是使用大负载.为此，您可以使用将截断目标表的执行SQL语句"任务来启动控制流(而非数据流).因此，每次运行包时，目标表都会被截断，最终您将加载源表中的所有内容.另一种方法是使用增量加载.在这里，您有很多可能性.查看此链接以了解更多详细信息在sis中增加负载的***方法

There are two ways to handle this. The easy way is to use bulk load. For this, you start your control flow (not data flow) with a Execute SQL Statement task that will truncate your destination table. So every time you run your package, the destination table will be truncated and you end up loading whatever in the source table. The other approach is to use incremental loading. Here you have many possibilities. Check out this link for more details Best way for incremental load in ssis