ssebring
asked on
ssis precedence contraint connector line not anchoring straight (cosmetic)
Hi,
Inside a sequence container that has multiple tasks, after connecting the tasks with a straight, centered precedence constraint, saving then reopening the package will invariably have 1 or more lines that are no longer straight.
Is there a known trick that anchors a straight connector line?
Thank you!
Inside a sequence container that has multiple tasks, after connecting the tasks with a straight, centered precedence constraint, saving then reopening the package will invariably have 1 or more lines that are no longer straight.
Is there a known trick that anchors a straight connector line?
Thank you!
It doesnt make any difference in your logic or functionality.
It is, indeed, a cosmetic thing and that bugs me, also. There are a couple of options:
1) Move the top of the connection to the middle of the bottom of the top box (how's that for convoluted ;-);
2) Make sure that the top boxes being connected are of the same size and are aligned (and, even then, you may need to tweak their location slightly to get the connectors to be straight ;-).
1) Move the top of the connection to the middle of the bottom of the top box (how's that for convoluted ;-);
2) Make sure that the top boxes being connected are of the same size and are aligned (and, even then, you may need to tweak their location slightly to get the connectors to be straight ;-).
ASKER
thanks for the replies!
Valentino -- Yes, tried mucho ways of resizing, aligning, placements prior to posting... thanks for the comment though.
Patel -- you are correct, my question is a cosmetic, not logic or functionality issue.
8080 -- thanks for the agreement! Have tried many things, nada. Didn't entirely understand your #1 suggestion, does the screenshot (before pic) represent what you are saying on that? (#2 suggestion, feel I've exhausted moving, sizing & aligning attempts).
Valentino -- Yes, tried mucho ways of resizing, aligning, placements prior to posting... thanks for the comment though.
Patel -- you are correct, my question is a cosmetic, not logic or functionality issue.
8080 -- thanks for the agreement! Have tried many things, nada. Didn't entirely understand your #1 suggestion, does the screenshot (before pic) represent what you are saying on that? (#2 suggestion, feel I've exhausted moving, sizing & aligning attempts).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
haha! yes! terrible 101 stuff. SSIS sql task editor is a mess when it comes to sql formatting (or lack of).
Thanks for the suggestion on BI-Xpress -- will check into it.
In defeat, going to go ahead and accept your last post as the final answer...
thx again for the replies!
Thanks for the suggestion on BI-Xpress -- will check into it.
In defeat, going to go ahead and accept your last post as the final answer...
thx again for the replies!
Hi!
I struggled with this for a while, even had some sleepless nights being OCD about "Package Polish".
What I found worked for me was to enable the Layout Toolbar in BIDS - you can do this through the file menu by selecting View—>Toolbars—>Layout
From there, highlight all the objects in your package, the hit the Align Centre button.
Another more cosmetic method is to highlight an object and use the CTRL + <cursor> to align the precedence constraint.
A final tip is to enable the precedence constraint labels. For you need to go into the file menu in BIDS (Tools—>Options—>Business Intelligence Designers—>Integration Services Designers) and check the box ‘Show precedence constraint labels’ in the Accessibility section.
I credit this information to a blog I read previously,
Hope this helps.
I struggled with this for a while, even had some sleepless nights being OCD about "Package Polish".
What I found worked for me was to enable the Layout Toolbar in BIDS - you can do this through the file menu by selecting View—>Toolbars—>Layout
From there, highlight all the objects in your package, the hit the Align Centre button.
Another more cosmetic method is to highlight an object and use the CTRL + <cursor> to align the precedence constraint.
A final tip is to enable the precedence constraint labels. For you need to go into the file menu in BIDS (Tools—>Options—>Business Intelligence Designers—>Integration Services Designers) and check the box ‘Show precedence constraint labels’ in the Accessibility section.
I credit this information to a blog I read previously,
http://denglishbi.wordpress.com/2009/02/01/integration-services-ssis-package-designing-tips/.
Hope this helps.
Maybe try resizing the SQL tasks (enlarge them just a little), re-align, save and open, see if that solves the cosmetic issue?