dbTalk Databases Forums  

DTS Designer for ActiveX Script Tasks Loses Script Pane???

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS Designer for ActiveX Script Tasks Loses Script Pane??? in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
John Saunders
 
Posts: n/a

Default DTS Designer for ActiveX Script Tasks Loses Script Pane??? - 01-03-2006 , 06:27 PM






(I just got through praising DTS to a colleague who hadn't used it since a
bad experience with it back in SQL 7.0. Good thing I didn't show him the
following!)

I've somehow broken the DTS Designer.Here's what happens now.

1) Create a new package
2) Drop an ActiveX Script Task onto the design sheet
3) Note that the left-hand pane with the Language and Browser tabs, shows
up, but the right-hand pane does not. Not at all.

One big hint is that when I pull down the Language dropdown, it extends past
the right edge of the screen, as though it thought that the screen width
were infinite. Although this may be a big hint to someone, it's meaningless
to me!

Strangely, I can drag two connections and create a transform data task
between them, and add an ActiveX Transform. In this case, the script pane is
displayed.

In general, when I lose a split pane like this, I move the mouse back and
forth across the window until I see the "splitter" cursor. In this case, I
never see a splitter cursor. Furthermore, when I do grab the right edge of
the window and resize it horizontally, the window will not resize smaller
than about 600 pixels wide (a bit less than 640). When I attempt to resize,
I get a "flash" of the "right edge", complete with minimize and maximize
buttons.

I've tried all combinations of minimize and maximize that I can think of.
I've also poked around in the Registry and in Application Settings to see if
I could see something that looked like it might be DTS' idea of the
appropriate window size. But I found nothing.

Can anyone help? I hope I don't have to reinstall SQL Server because of
this!

Thanks,
John Saunders



Reply With Quote
  #2  
Old   
John Saunders
 
Posts: n/a

Default Re: DTS Designer for ActiveX Script Tasks Loses Script Pane??? - 01-03-2006 , 06:52 PM






I love it when I answer my own question!

In the registry, HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
Server\80\DTS\ActiveXWindowPosition, value "splitterpos" was 0x78008676
(2013300342). That's a bit past the right side of my screen...

"xtranssplitterpos" was set to 0xd0, explaining the difference.

Thanks!

John Saunders



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.