在外部 DLL 中使用 SSIS 数据流行
在许多跨包的 SSIS 数据流中,我们通过脚本转换调用某种服务。我想通过从脚本任务中消除 Web 服务相关代码和对象创建/转换代码来促进重用,并将其放入一小组可重用库中。
我想将行数据传递给常用方法,而不需要 20、30、40 等方法参数,并且想听听社区如何有效地将行从 SSIS 传递到外部库。
In many of our SSIS data flows across packages we call into a service of some kind from a script transform. I would like to promote reuse by eliminating web service related code and object creation/conversion code from the script tasks, and put it into a small set of reusable libraries.
I would like to pass the row data to the common methods, without having 20, 30, 40 etc. method parameters, and would like to hear from the community how to effectively pass row(s) from SSIS to external libraries.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
如果您进入工具选择工具箱项,则可以将特定的 DLL 添加到 BIDS 中的工具箱中。然后您可以像任何其他任务一样使用它们。您的所有开发人员都必须将您想要使用的组件添加到他们的 BIDS 中。我们已经使用几个本地创建的组件和一些从其他来源获得的组件来完成此操作。不知道你到底想添加什么,我不能保证你可以添加它们,但这是我首先尝试的。
If you go to the tools choose toolbox items, you can add specific DLLs to the toolbox in BIDS. Then you can use them like any other task. All of your developers would have to have the components you want to use added to their BIDS. We have done this with several locally created components and a few we got from other sources. Not knowing exactly what things you want to add, I can't guarantee you can add them, but it's what I woudl try first.