none
SSIS Package - When opened in designer shows nothing because it is scrolled to bottom right where there are no tasks? RRS feed

  • General discussion

  • Hi,

    I have logged a similar thread previously but want to try again.

    Problem:

    When I open an existing SSIS packages in BIDS it shows no tasks, because it is scrolled all the way to the bottom right, if I then use the scrollbars and scroll left and then up I can see my SSIS package contents.

    Current Resolution:

    Using this works: from the menu bar select: Format > Auto Layout > Diagram

    BUT this re-organizes all my tasks! which i do not want!

    Is there any solution to manually tweak / edit the xml of the SSIS package to fix this without losing my original package layout?


    I.W Coetzer
    Wednesday, May 11, 2011 8:33 AM

All replies

  • Welcome to the wonderful world of the SSIS GUI!

     

     

     

    (There is no solution for this problem)


    MCTS, MCITP - Please mark posts as answered where appropriate.
    Wednesday, May 11, 2011 8:43 AM
  • So is there anything down in the bottom right corner at all?  Perhaps maybe an Annotation or something.
    Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD
    Wednesday, May 11, 2011 8:58 AM
  • Finally! found a solution and fixed up all my SSIS packages!!!

     

    http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/23f66a33-24a3-466f-9834-1e09aa4bb9fa/

     

    Full Solution:

     

    1. In BIDS (Visual Studio) first close all open SSIS packages / xml files to avoid confusion ...

    2. Right click on the SSIS package and select the "View Code" menu item. (to open the actual xml)

    3. Search for all instances of "PersistedZoom" and change the value directly to the right of it to 100 (mine was 80 or 90 ...)

    4. Now save and close the XML file.

    5. Now open the SSIS package in the designer, you will notice that it is still scrolled to the bottom right!

    6. Now make any small change (I scrolled to the top-left and just slightly moved a task)

    7. Now save and close the designer

    8. Re-open the SSIS package in the designer! and what do you know it does not start scrolled down to the bottom right anymore!

     

    Let me know if you still have issues - but as I said I followed this same process on all my problem packages and they ALL now open correctly.

    I noticed that after doing all this the PersistedZoom property disappeared from the xml, which leads me to believe that if I zoom in and out of my packages again it will probably get stuck by opening to the bottom right again ...


    I.W Coetzer
    Wednesday, May 11, 2011 9:06 AM
  • Good find.  Will bookmark this link for sure.
    Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD
    Wednesday, May 11, 2011 9:08 AM
  • Allright! So there finally is a solution for this annoying problem.

    A colleague of mine told me editing the XML doesn't work, but apparently he was wrong...


    MCTS, MCITP - Please mark posts as answered where appropriate.
    Wednesday, May 11, 2011 9:13 AM
  • Yes, please test on one of your own SSIS packages that have this problem and let us know if it also works for you.

    Cheers,

    Ian


    I.W Coetzer
    Wednesday, May 11, 2011 12:46 PM