返工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屋！