sql server data warehouse: Hi!

I'm involved in building a medium sized ware house with MS SQLServer 2000=20
as the backend. I've been searching for some good tools for SQLServer to=20
help me with the demanding tasks of planning and building the database and =

(preferrably the same tool) making the mappings and data transformations=20
when populating the database, but still I've not come across any that has=20
satisfied my needs. Oracle has a great tool for this called Oracle=20
Warehouse Builder, but haven't seen anything like it for MS databases.=20

Therefore I'm asking: Does anyone know about a tool that can be used in=20
planning, deploying and maintaining a data warehouse built on a MS=20
SQLServer 2000? Doesn't matter if it has a price tag on it or not :)

-----------------------
S=F6ren Hakola
Finland

I think that anyone that uses SQL Server to deploy a Data Warehouse... uses SQL Server 2000 capabilities only. And it's cheeper :)

- Diagram: create logic models with direct link to the table
- Tables: Info repositor
- Data Transformation Services (DTS): ETL, data transformation (populate the tables
- Jobs: schedule DTS for automatic ET
- Analysis Services: If you desire to work with a MOLAP too

Other tools
Data Stage (Unix and Windows, all databases) - Top tool, expensiv
Informatica (Unix and Windows, all databases) - Top tool, expensiv

Thanks for the response. I'll check those out!

Greetings
S.