Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Variables Display Gone Expand / Collapse
Author
Message
Posted Wednesday, August 1, 2012 8:33 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, September 8, 2013 9:25 AM
Points: 96, Visits: 495
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
Post #1338589
Posted Wednesday, August 1, 2012 10:38 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, July 25, 2014 8:32 AM
Points: 488, Visits: 1,859
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'.
Post #1338673
Posted Wednesday, August 1, 2012 11:12 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 1:13 PM
Points: 561, Visits: 4,910
There should be an SSIS menu. Variables should be available from there.
Post #1338688
Posted Wednesday, August 1, 2012 11:15 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, September 8, 2013 9:25 AM
Points: 96, Visits: 495
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
Post #1338690
Posted Wednesday, August 1, 2012 11:16 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, September 8, 2013 9:25 AM
Points: 96, Visits: 495
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
Post #1338694
Posted Wednesday, August 1, 2012 11:19 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 1:13 PM
Points: 561, Visits: 4,910
What version of BIDS are you using?
Post #1338698
Posted Wednesday, August 1, 2012 11:24 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, September 8, 2013 9:25 AM
Points: 96, Visits: 495
I'm using 2008 version 9.0.*

Regards:
Mordred
Keep on Coding in the Free World
Post #1338701
Posted Wednesday, August 1, 2012 11:25 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, July 25, 2014 8:32 AM
Points: 488, Visits: 1,859
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.
Post #1338703
Posted Wednesday, August 1, 2012 12:41 PM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, September 8, 2013 9:25 AM
Points: 96, Visits: 495
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
Post #1338760
Posted Wednesday, August 1, 2012 1:15 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:24 AM
Points: 12,887, Visits: 31,835
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
Post #1338777
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse