ssis中黑白执行包任务和执行进程任务选择哪一个
我需要一个关于在 ssis 中执行包任务和执行进程任务之间进行选择的建议及其优缺点。
要求是我需要通过将一些变量从父包传递到子包来从父包运行子包。我尝试使用执行包任务并将变量传递给子包一切正常。现在我来了跨越一个新的要求，我需要在从父包调用时将配置文件传递给子包。我无法做到这一点。所以现在我尝试使用执行进程任务执行相同的操作，其中我传递的可执行文件是我的子包。现在的问题是我无法读取父包中的变量，也不能能够弄清楚如何读取配置文件。
非常感谢任何帮助。
谢谢
i need a suggestion in choosing between execute package task and execute process task in ssis with its pros and cons.
The requirement is that i need to run the child package from the parent package by passing some of the variables from the parent to child package.i tried using execute package task and also passed the variables to the child package everything works fine.Now i came across a new requirement where i need to pass the configuration file to the child package while calling from parent package. I was not able to do it.So now i am trying to do same using execute process task where the executable i am passing is my child package.Now the problem is that i am unable to read the variables in the parent package and also not able to figure it out how to read the configuration file.
Any help is highly appreciated.
Thanks
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
对于 SSIS 2005/2008，它更多地是来自孩子的拉力而不是推动力。您可以创建需要“传递”的变量，然后使用配置管理器使其可用。
msdn 中的此链接应该有所帮助：如何：在子项中使用父变量的值套餐
With SSIS 2005/2008 it's more of a pull from the child than a push to it. You can create the variables that need to be "passed" then use configuration managers to make it available.
This link from msdn should help: How to: Use the Values of Parent Variables in a Child Package