My first post here. It's probably a very easy, or not question, but I'm new to Data warehousing and to DTS's.
Does anyone know of a way to retrieve the information stored in several DTS's?
I have some that are working and being updated and in use, however, since the people who made them, left... we need to understand the how and what the DTS's do.
Is there any way to retrieve this, without opening each DTS, retrieving the Query it uses and so on.
Thank you for reading.