June 5, 2006 at 1:05 pm
I am using SQL Server 2005 Management Studio to management SQL Server 2000 servers. I have downloaded the DTS editor and it works under the Legacy tab. But when I have a DTS package the Query editor seems to loose functionality. The Control-C and Control-v keys seem not to work consistently. The Toolbar buttons like "Execute" the query are grayed out. When I close the DTS package it all comes back.
Is anyone else experiencing this and is there a patch?
Thanks
Steve
June 6, 2006 at 5:59 am
Honestly, I haven't spent too much time looking for a fix, but understanding the fact that DTS is depreciated in SQL2005, and with the plan to some time migrate them to SSIS, I continue to use SQLEM for DTS and Management Studio for anything else...
June 6, 2006 at 6:35 am
I have experienced similar issues. In my example the arrow keys and backspace keys on the keyboard do not work.
I have not found a patch, if you find one can you please update this post?
I'll do the same.
Keith
June 6, 2006 at 7:38 am
January 9, 2007 at 1:31 pm
same thing
any clue, someone?
January 9, 2007 at 2:27 pm
Is SP1 for SQL 2005 applied ?
January 10, 2007 at 3:37 am
There seems to be no where around it, beside i strongly advise you to use the SQLEM for editing the DTS.
Using the 2005 module has wasted lots of my time because if your DTS has a FTP task in it. It will get all messed up:
1. You won't be able to edit the FTP task from the SQLEM.
2. The FTP task tries to read the source files from "your" directories insteard of the "server" directories.
Thank you.
June 19, 2008 at 9:01 am
Opening a 2nd SQL Mgmt Studio and running queries from the 2nd Mgmt Studio seems to fix the keyboard issue.
However, I still can't use delete, arrows, backspace,etc. from the 1st Mgmt Studio's query window.
As soon as I close the legacy DTS window, the keys work properly on the 1st Mgmt Studio.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply