April 28, 2008 at 1:15 pm
I'm using SQL Server 2005 Client on my PC.
As soon as I open DTS package
from Management/Legacy/Data Transformation Services,
Management Studio Query Analyzer becomes non-editable.
Is it a bug?
SQL Server 2005 SP2 didn't fix the problem.
Thanks,
Rob
April 28, 2008 at 2:11 pm
Most likely, it's "modal". Have you been able to get back to Management Studio by closing the DTS package?
(I don't have any DTS packages to test this on. Just SSIS. So I'm kind of guessing.)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 28, 2008 at 9:55 pm
Yes. As soon as I close DTS Designer
Management Studio functions fine again.
Any suggestions how to fix it?
Rob
April 29, 2008 at 7:42 am
The only suggestion I have is convert from DTS to SSIS, but that's not a very helpful suggestion. Sorry I can't help on this one. Don't know what you should do.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 29, 2008 at 9:15 am
Redesign it using SSIS is not an option.
I don't need any DTS or SSIS.
I am redesigning it as a stored procedure.
Transformations are done on the same server.
No need in DTS/SSIS. But I'm constantly have to open DTS
to extract SQL code and to verify the logic.
So far I had to use Notepad++ to paste DTS SQL code
but it's not the best option because I have to test SQL blocks quite often.
If anybody resolved this issue please let me know
how you did it.
Thanks,
Rob
April 29, 2008 at 7:02 pm
even i had the similar scenario and dealt the same way. i havent found any way out yet.
good luck with your task of opening and closing DTS.
April 30, 2008 at 1:45 am
Just open a second instance of management studio. You can then copy the code from one place to another.:rolleyes:
April 30, 2008 at 6:48 am
WFAGG,
Thank you! This helped.
In second instance of management Studio QA works fine.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply