Paul - Im not sold on DTS, even though I use it a lot for moving data around. I think at some point you hit the wall and have to write code - which accounts for the majority of our DTS questions - and once you write code, I'm not sure it's the right environment. So far I don't use it for much besides scheduled moving of data, that kind of thing. Have been experimenting with writing COM add in's to see how that would work.

OLAP, Data mining, so far almost no use. I count it as my weakest area. Only way to improve is to find a project, haven't had the time to find a project or do it either!

Right now I'm just finishing an application for another part of our IS team, developers were overbooked and I had time, so why not? Other than that, I'm replicating about 230 dbs, which makes for great fun when you have to apply schema changes to all 230. But no, nothing REALLY exciting.

Andy