返工SSIS工作 - 两次调用现有工作 [英] Rework SSIS job - call existing job twice
问题描述
我创建了一个SSIS作业,它从系统下载数据并将其传输到SQL。 它工作正常并处于生产状态。
我想重新设计此系统以上传数据。 计划是调用下载例程刷新数据,运行新的上传例程,然后再次调用下载例程来获取上传例程中执行的任何更新。
我不会我认为自己是SSIS的专家,并考虑如何做到这一点? 理想情况下,我希望避免创建任何新的dtsx文件,因为部署它们有点痛苦。
TIA
< blockquote>
好的,如果我理解正确的话。
任务A将数据从SystemPippo下载到TableSQL
任务B从TableSQL上传数据到SystemPippo
任务C将数据从SystemPippo下载到TableSQLTemp
任务D比较TableSQL和TableSQLTemp以查看SystemPippo中是否有更新任务A和B.
它看起来像是一个无限循环。
I've created an SSIS job which downloads data from a system and transfers it to SQL. It works fine and is in Production.
I want to rework this system to upload data also. The plan is to call the download routine to refresh the data, run a new upload routine, and then call the download routine again to fetch any updates carried out in the upload routine.
I wouldn't consider myself an expert in SSIS and thinking about how to do this? Ideally I would want to avoid creating any new dtsx files as deployment them is a bit painful.
TIA
Ok, If I understand correctly.
Task A Download data from SystemPippo to TableSQL
Task B Upload data from TableSQL to SystemPippo
Task C Download data from SystemPippo to TableSQLTemp
Task D Compare TableSQL and TableSQLTemp to see if there was some update in SystemPippo during the task A and B.
It looks to me as an infinite loop.
这篇关于返工SSIS工作 - 两次调用现有工作的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!