基于SSIS的GUI
我正在寻找能够为 SSIS 提供更简单、更直观的 GUI 的供应商。我们的想法是重用 SSIS 运行时,但同时为用户提供更简单的 GUI。所以这样的GUI将提供SSIS兼容的包(xml)。
有人知道这样的工具吗?
感谢您的帮助!
I'm looking for a vendor who provides simpler , more intuitive GUI for SSIS. Our idea is to reuse SSIS run-time but in the same time providing simpler GUI for a user. So such GUI will provide SSIS compatible packages (xmls).
Is anybody aware of such tools?
Appreciate your help!
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(4)
实际上没有任何其他 GUI 可用于交互式开发 SSIS 包。您拥有来自 Pragmatic Works 的软件,该软件与 SSIS 集成,添加了模板和可重用性,但它的核心仍然是 SSIS。
您还可以使用 C# 以编程方式开发 SSIS 包 - 但这些包可能无法在 SSIS 中很好地打开 - 因为它们只有控制/数据流定义,然后保存到 dtsx。
请参阅 http: //blogs.msdn.com/b/mattm/archive/2008/12/30/samples-for-creating-ssis-packages-programmatically.aspx 用于 SSIS 以编程方式,以及 http://pragmaticworks.com/Products/ 了解 Pragmatic Works 的可能性。
There aren't really any other GUIs for developing SSIS packages interactively. You have software from Pragmatic Works that integrates with SSIS adding template and reusability, but it's still SSIS in the core.
You can also develop SSIS packages programatically using C# - but these packages probably won't work well opened in SSIS - as they just have the control/data flow definitions and then saved to dtsx.
See http://blogs.msdn.com/b/mattm/archive/2008/12/30/samples-for-creating-ssis-packages-programmatically.aspx for SSIS Programatically, and http://pragmaticworks.com/Products/ for Pragmatic Works possibilities.
尝试 Keelio 软件
http://www.keelio.com/Brochures/Keelio_Software_Products_Manual.pdf
Try Keelio Software
http://www.keelio.com/Brochures/Keelio_Software_Products_Manual.pdf
在 sqlbits 看到 varigence 的演示就是这样做的。我自己没有尝试过,因为它与第三方组件不兼容。从演示来看,它看起来像是一个不错的工具
https://www.varigence.com/products/mist
Saw a presentation by varigence at sqlbits that does just this. I haven't tried it myself as it is/was not compatible with third party components. looked like a nice tool though from the demo
https://www.varigence.com/products/mist
eSSIS 由 Dualcorp 开发。你可以在 nuget 中找到一个试用版。
eSSIS developping by dualcorp. You can find a trial into nuget.