根据上次修改日期附加数据 [英] Append data based on last modified date
问题描述
我想创建一个SSIS包,它将数据从一个SQL服务器A插入另一个SQL服务器B表。
I want to create an SSIS package which will insert the data from one SQL server A to another SQL server B table.
我们计划创建一个工作,从服务器A到服务器B表获取基于最后修改数据的新条目。
We are planning to create a job which will get the date from server A to server B table only the new entries based on last modified data.
现在我的包正在每次运行SSIS包时插入所有内容。
Right now my package is inserting everything every time I run the SSIS package.
任何帮助将不胜感激。
simam
推荐答案
嗨Simam,
Hi Simam,
好像你是谈论SSIS中的增量加载。
It seems that you are talking about incremental load in SSIS.
如果表格中已有时间戳字段,则可以使用条件拆分来过滤掉新数据。
If there is already a timestamp field in your table, then you can use conditional split to filter out the new data.
请参考以下链接,如果您有任何疑问,请随时询问:
Please refer to the following links, if you have any question, feel free to ask:
这篇关于根据上次修改日期附加数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!