SSIS 2012 使用项目部署模型将值从子包传递到父包 [英] SSIS 2012 pass values from child package to parent with project deployment model

问题描述

我正在使用新的项目部署模型.

i'm using the new project deployment model.

我有一个名为 ETL 的主包.我的 ETL 包所做的第一件事是运行一个名为 get SFTP files 的包，如图所示.

I have a master package called ETL. The first thing my ETL package does is run a package called get SFTP files as shown.

在获取 SFTP 文件中，foreach 循环获取 ClientID.我如何将此值传递回父包 ETL???做插入等

Within Get SFTP files a foreach loop gets the ClientID. HOW do i pass this value back to the parent package ETL??? To do inserts etc.

推荐答案

我曾与几位专家讨论过这个问题，在 SSIS 中没有 NATIVE 方法可以做到这一点.我确实看到有人提到过这样做的方法，这实际上是脚本任务中的一个 hack，但是任何读取此存储的人都会将您的变量结果放入表中并从那里引用.执行包任务上的参数绑定目前是单向街道父 --> 子.

I have spoken with a couple experts about this there is no NATIVE way of doing this in SSIS. I did see a mention about a way of doing this which is effectively a hack in a script task, but anyone reading this store results from your variables into a table and reference from there. Parameter binding on the execute package task is currently a ONE way street Parent --> Child.

这篇关于SSIS 2012 使用项目部署模型将值从子包传递到父包的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！