|
|
|
SSC Journeyman
      
Group: General Forum Members
Last Login: Friday, May 17, 2013 4:14 PM
Points: 91,
Visits: 472
|
|
Hi all,
I just got into work and started up BIDS to find that my variables display is blank. The tab was there but now that is even gone. When it was blank, I clicked View-->Other Windows-->Variables but that took the blank tab away. Now when I click View-->Other Windows-->Variables nothing happens in the BIDS interface. The variables display is now gone and will not come back. Anyone run into problems like this before? If yes, is there a work around that doesn't involve a re-install?
Regards: Mordred Keep on Coding in the Free World
|
|
|
|
|
SSC Veteran
      
Group: General Forum Members
Last Login: Today @ 9:36 AM
Points: 240,
Visits: 1,093
|
|
| I've run into this behavior on occasion. The approach I've found most consistent in recovering the display is to right click the general background for the package and select 'Variables'.
|
|
|
|
|
Mr or Mrs. 500
      
Group: General Forum Members
Last Login: Tuesday, April 16, 2013 5:38 AM
Points: 557,
Visits: 4,818
|
|
| There should be an SSIS menu. Variables should be available from there.
|
|
|
|
|
SSC Journeyman
      
Group: General Forum Members
Last Login: Friday, May 17, 2013 4:14 PM
Points: 91,
Visits: 472
|
|
kl25 (8/1/2012) I've run into this behavior on occasion. The approach I've found most consistent in recovering the display is to right click the general background for the package and select 'Variables'.Thanks for the feedback. I've tried that multiple times with hopes that "this time" it will show up but they do not.
Regards: Mordred Keep on Coding in the Free World
|
|
|
|
|
SSC Journeyman
      
Group: General Forum Members
Last Login: Friday, May 17, 2013 4:14 PM
Points: 91,
Visits: 472
|
|
Charles Hearn (8/1/2012) There should be an SSIS menu. Variables should be available from there.Yes there is, View-->Other Windows-->Variables but that did not display them either. The whole Variables window is gone for some reason.
Regards: Mordred Keep on Coding in the Free World
|
|
|
|
|
Mr or Mrs. 500
      
Group: General Forum Members
Last Login: Tuesday, April 16, 2013 5:38 AM
Points: 557,
Visits: 4,818
|
|
| What version of BIDS are you using?
|
|
|
|
|
SSC Journeyman
      
Group: General Forum Members
Last Login: Friday, May 17, 2013 4:14 PM
Points: 91,
Visits: 472
|
|
I'm using 2008 version 9.0.*
Regards: Mordred Keep on Coding in the Free World
|
|
|
|
|
SSC Veteran
      
Group: General Forum Members
Last Login: Today @ 9:36 AM
Points: 240,
Visits: 1,093
|
|
Hmm. Now you have me puzzled. A google search came up with the following from MSDN:
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/94cc1c91-f699-481a-be91-703a912b0f2b/
Hopefully this approach will help. Haven't ever gotten to the point where the window won't recover from the right click/variables method but it sounds like the next step may be to try the window layout refresh.
|
|
|
|
|
SSC Journeyman
      
Group: General Forum Members
Last Login: Friday, May 17, 2013 4:14 PM
Points: 91,
Visits: 472
|
|
kl25 (8/1/2012) Hmm. Now you have me puzzled. A google search came up with the following from MSDN:
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/94cc1c91-f699-481a-be91-703a912b0f2b/
Hopefully this approach will help. Haven't ever gotten to the point where the window won't recover from the right click/variables method but it sounds like the next step may be to try the window layout refresh.I tried to reset my window layout, then clicked view, other windows, and then variables but still the window is not showing up. So frustrating as I need to create more variables in my package. Argh! Thanks for the link though, it's too bad it didn't work for me.
Regards: Mordred Keep on Coding in the Free World
|
|
|
|
|
SSChampion
        
Group: General Forum Members
Last Login: Today @ 10:11 AM
Points: 11,609,
Visits: 27,658
|
|
if you think the variables popup might be showing up outside of the desktop space(like when you switch from dual monitor to single, and stuff is outside of scope)
a lot of times if you change your screen resolution from current to something smaller(ie 1600x1200 to 1200x768) , the OS will move alll windows into the new desktop area so you can get it to float int he touchable area again.
then you can change it back to normal again.
see if that works for you.
Lowell
--There is no spoon, and there's no default ORDER BY in sql server either. Actually, Common Sense is so rare, it should be considered a Superpower. --my son
|
|
|
|