New Datawarehouse

What is the best way to set up a datawarehouse? Do I use replication or dts
packages or what? What I need to do is archive production data every two
weeks to this datawarehouse. Then I will need to be able to query the
archive data. What is the best way to do this? And how do I go about doing
it?
Thanks in advance for the help.
Dave> What is the best way to set up a datawarehouse? Do I use replication or
dts
> packages or what? What I need to do is archive production data every two
> weeks to this datawarehouse.
DTS seems more appropriate in this scenario.
> Then I will need to be able to query the
> archive data. What is the best way to do this? And how do I go about doing
> it?
DW is usually 1st step - next step are OLAP cubes. Do please read more on
OLAP in Books OnLine, I guess this is what you need.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com