Meaning of arrangements of icons

[rac2]

In a diagram for a package I created and saved using the Export Wizard there are two pairs of connections. The export involved four tables, exporting from SQL Server to Access. Connection 1 and 3 represent SQL Server and Connections 2 and 4 represent the same Access database.

The diagram uses one pair of connections for two of the tables and another pair for the other tables.

I have added more tables to this package using the GUI, dragging and dropping icons and completing the dialog boxes. The package now exports 7 tables, for some tasks I used Connections 1 and 2, for others I used 3 and 4, just to divide up the work. Each connection appears repeatedly, so I have 4 icons for Connection 1, 4 for 2, 3 for Connection 3 and 3 for 4.

There are no precedence arrows between the various exports.

I am wondering what is the significance of having multiple connections? Would it be possible to construct the diagram and the package with only one icon for each connection? And place multiple task arrows between one pair of connections? And would it mean anything different than repeatedly using the same connection with the different tasks?

 

[SimeonJ]

It sounds like you have way too much clutter in your package. the connection is only used to specify what server/database you are using. If everything resides on the same server(even if the data is in different databases) you only need one connection.