SQL Server Performance Forum – Threads Archive

Existing DTS Designer graphical interface is blank

<br /><br /><br />Existing DTS Designer graphical interface is blank when viewing packages remotely. I can view the packages on the server but not using the Enterprise Manager remotely. How can I correct this? [<img src=’/community/emoticons/emotion-6.gif’ alt=’‘ />]<br /><br />1/24/2005<br />Uninstalled, reinstalled, upgraded service packs, rebooted, upgraded MDAC and nothing worked. I still get the DTS console window with nothing but the standard menu bar ( not the DTS menu bar)<br /><br />Thanks anyway!! Any other suggestions?

---

Welcome to the Forum.!
EM is a gui tools and very slow.
First time or did you see graphical interface before?
Luis Martin
Moderator
SQL-Server-Performance.com Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
Leonardo Da Vinci Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte
All postings are provided “AS IS” with no warranties for accuracy.

---

May be a problem with client tools, try from another machine or remotely logging on to the server.
Also ensure the login used has required privileges to perform the action. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

EM Worked before. This just started happening. Now I have to log onto the server to access any DTS packages.

---

Try replacing the client tools on that machine and also try applying service pack to the client tools. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

Check for the free space on the remote client machine..this has happend to me whenever i tried to open the big dts package & when there is very less space the package won’t open . Check the space for the local drive… Muthu

---

Tried that; I uninstalled, reinstalled, upgraded service packs, rebooted, upgraded MDAC and nothing worked. I still get the DTS console window with nothing but the standard menu bar ( not the DTS menu bar)<br /><br />Thanks anyway!! Any other suggestions?<br />[<img src=’/community/emoticons/emotion-6.gif’ alt=’‘ />]<br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by satya</i><br /><br />Try replacing the client tools on that machine and also try applying service pack to the client tools.<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Contributing Editor & Forums Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">

---

1/24/2005
Uninstalled, reinstalled, upgraded service packs, rebooted, upgraded MDAC and nothing worked. I still get the DTS console window with nothing but the standard menu bar ( not the DTS menu bar) Thanks anyway!! Any other suggestions?

---

1/27/2005<br />Uninstalled, reinstalled using a different install disk, upgraded service pack to sp3a, rebooted and <br /><b>"<u>IT WORKED</u>"</b>.<br /><br /><b>Thank You All for your Suggestions!![<img src=’/community/emoticons/emotion-2.gif’ alt=’‘ />]</b><br /><br />Now I have a new problem to be posted later. When I use the SQL Enterprise Manager (SEM) Return All Rows option to open a table, or you attempt to create or design a view, I get the following error: <br /><br /><center><font color="red"><u><b>An unexpected error happened during this operation.</b></u></font id="red"></center><br /><br />Any suggestions[?]

---

]]>