Where is the DTS Stored?

[jymm]

This is kinda an odd question.

I have a boat load of DTS on my server. One that I needed some SQL code from is having Enterprise manager behave a bit oddly.

Here is the situation: Any user with Enterprise manager goes into the design mode for this DTS. Right clicks on the 'Execute SQL Query task' (only one in this DTS) and selects Properties. If at this point you press the 'Build Query' button (there is a HUGE query in this DTS and you can cut & paste it just fine before today) Enterpise manager hangs (not responding).

Not sure if the problem is where the DTS is stored or something else, but other DTSs with similar amounts of code are just fine.

ideas?

 

[TonyKhela]

Well, haven't seen a problem like this before but the DTS packages are stored in the MSDB database.
Hope this helps
TK