在 SSIS 中，是否可以在数据流任务中自动排列项目? [英] In SSIS, is it possible to auto arrange items in a data flow task?

问题描述

我正在 SSIS 中构建一个项目.虽然该项目按我希望的方式工作(这很重要，对吗?)，但其他人则被数据流任务的丑陋"放置以及它们之间的连接线困扰".

I'm building a project in SSIS. While the project works as I want it to work (that's what counts, right?), others are "bothered" by the "ugly" placement of the data flow tasks and the connector lines between them.

我手动将项目移动到地图上更好的位置，但只能调整连接线这么多.我包含的屏幕截图(希望你能看到)向你展示了现在的情况.

I manually moved the items to better locations on the map, but can only adjust the connector lines so much. The screenshot I included (which I hope you can see) shows you where things are now.

我尝试寻找自动排列"或类似的东西，但在菜单栏中或通过右键单击找不到任何内容.有没有办法自动排列数据任务项，让它们看起来更好?

I tried looking for "Auto Arrange" or something similar and could find nothing in the menu bar or by right clicking. Is there some way to auto arrange the data task items so they look better?

如果有什么不同，我将使用 SSIS 2012.

I'm using SSIS 2012 if that makes any difference.

推荐答案

因此，从技术上讲，虽然有自动布局功能，但无法通过右键单击图表本身立即访问.

So it appears that while there is -- technically speaking -- an Auto Layout feature, is not immediately accessible by right-clicking the diagram itself.

我在我认为最不可能的地方偶然发现了它:

I found it by chance in what is to me the most unlikely of places:

格式 > 自动布局 > 图表

选择该菜单选项后，它会排列图表.它对我来说足够好，但不足以满足我团队中要求视觉清洁的其他人.

On selecting that menu choice, it arranges the diagram. It does so well enough for me, but not well enough to satisfy others in my team who demand visual cleanliness.

哦，好吧.

这篇关于在 SSIS 中，是否可以在数据流任务中自动排列项目?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！