Hello to all, I am not a big fan of DTS to me it is useful for small tasks that don't require much effort, however if you are trying to move millions of records i rather have a DBlink and develop a stored procedure that allows me to have complete control over it.

I recently became in contact with OLAP, in fact i am still learning about it , so far, i find it to be a use full tool helps improve the reporting time and in a call center environment where you get a record fort every call you receive, I can say it is quite useful to improve processing time, how ever it still depends on a relational database to full fill its purpose and as a data lover i am, i am not very fond of having to generate a second database (the OLAP database) to build a cube, to me is replicating information, and when you are talking about a 5,000,000 records and that is just on one table, this is madness, sure, you don't put al records on the cube you summarize and all but still you are still taking lots of space on the server (our relational database is over 200 gig), that in some cases you have to share with the relational db to save expenses, it sounds to me like a big investment in time, money and effort just to make you're reports faster i agree the functionality's that it offers are great, however there might be room for improvement on the data side, why not generate beta index technology or tridimensional tables, any ways that is just my opinion.

regards

Charly

P.S NO'p my name is not badly written.

"Everything in life happens for a reason and helps you become what you are today"