Hi - I am continuing to hang my EM sessions when trying to define a transformation on a very large DB (a SAP DB with 15,000 tables). All I want to do is copy 15 tables routinely into another db for analysis services, but when trying to define this DTS wants to read all table information and hangs. I have 1.5gig of RAM, and a strong dual xeon 700 machine, but it just doesn't want to work (even after 20 minutes).
Does anyone have any tips or links to a tool that will let me explicity define the tables rather than provide me a list from the entire DB?
Any help is greatly appreciated.