ssis precedence contraint connector line not anchoring straight (cosmetic)

Posted on 2011-04-27
Last Modified: 2012-08-16

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!

 before and after saving a package
Question by:ssebring
    LVL 37

    Expert Comment

    Hmm, that's weird, I don't really remember this happening.  Though I'm working with team members who sometimes forget to align the objects so maybe I just never noticed this "feature" before.

    Maybe try resizing the SQL tasks (enlarge them just a little), re-align, save and open, see if that solves the cosmetic issue?
    LVL 21

    Expert Comment

    by:Alpesh Patel
    It doesnt make any difference in your logic or functionality.
    LVL 22

    Expert Comment

    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 ;-).

    Author Comment

    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).
    LVL 22

    Accepted Solution

    Yes, the first screen shot represents the results of suggestion #1.  (And, yes, I get frustrated with Microsoft's screwing around with what I have on the screen before saving it! ;-)  

    I am trying to get my employer to buy at least one license of BI-Xpress so that I can use it to make my life easier with regard to several aspects (including better placement of components) of developing  in SSIS.  I don't know if some of the features of that tool will address this particular quirk in BIDS , though.

    I have even gone so far as to start a new project and to copy components across to it in order to get things to align and stay aligned. :-/

    To my way of thinking, it is kind of like what Microsoft does to the formating of SQL statements.  It is much easier to read both an SSIS package and SQL statements if they are decently formatted.  Microsoft screws around with both of those and totally messes with formatting on many occasions.

    Author Comment

    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!


    Expert Comment


    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.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
    Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now