Problem Viewing Query

[ha1ls45]

Hi all,
I have a problem with just one DTS Package on my server. I can open up all other packages and double click on the little line with an arrow and get into where you can see the sql code. Well, I have one particular package that when I try to view the code it just locks up E.M. I have been able to get into this before... what could be holding this up?

Is there an alternative way to view the query within the Local Package?

Thanks,
Ha1ls45

 

[mrdenny]

There may be some processes on the SQL Server that is blocking your query to the database. When you try to view the query in the DTS package there is lots of code that gets run on the SQL Server to populate the drop downs and what not.

Open Query Analyzer and run sp_who2 and see if anything is blocking you while EM is hung.

Nope, the DTS editor is the only way.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com