CODEWITHSUNDEEP
ssis
user1043535
user1043535

Reputation:

In SSIS, is it possible to auto arrange items in a data flow task?

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?

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

Screenshot of SSIS Data Flow Task map

Upvotes: 17

Views: 15822

Answers (1)

user1043535
user1043535

Reputation:

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:

Format > Auto Layout > Diagram

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.

Oh well.

Upvotes: 34

Related Questions