Work with a db that I did not design, trying to wrap my head around what is going on. I've got a DTS package that includes a Transform Data Task, "SELECT * FROM synonyms where ITEM_TYPE ='test'"
I can't find any data object called synonyms...how do I locate the source of the "test" ITEM_TYPE?