dts and data warehouse

How do you implement data warehouse using DTS in SQL 2000 server?Check the "Creating and Using Data Warehouses" part in ooks OnLine, as a
start.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"supernova" <abc@.yahoo.com> wrote in message
news:OY3dYEFiEHA.2916@.TK2MSFTNGP12.phx.gbl...
> How do you implement data warehouse using DTS in SQL 2000 server?
>|||In addition to what Dejan Sarka posted, you might want to get a book on data
warehousing... I highly recommend Ralph Kimballs _Data Warehouse Toolkit_ as
a starting point.
"supernova" <abc@.yahoo.com> wrote in message
news:OY3dYEFiEHA.2916@.TK2MSFTNGP12.phx.gbl...
> How do you implement data warehouse using DTS in SQL 2000 server?
>|||Thanks for the advice. Can you please give me an idea first?
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:eFC3JnJiEHA.1356@.TK2MSFTNGP09.phx.gbl...
> In addition to what Dejan Sarka posted, you might want to get a book on
data
> warehousing... I highly recommend Ralph Kimballs _Data Warehouse Toolkit_
as
> a starting point.
>
> "supernova" <abc@.yahoo.com> wrote in message
> news:OY3dYEFiEHA.2916@.TK2MSFTNGP12.phx.gbl...
> > How do you implement data warehouse using DTS in SQL 2000 server?
> >
> >
>|||"supernova" <abc@.yahoo.com> wrote in message
news:e$hschKiEHA.1384@.TK2MSFTNGP10.phx.gbl...
> Thanks for the advice. Can you please give me an idea first?
Not really; data warehousing is a huge topic. The question, "how do I
create a data warehouse using DTS" is almost akin to asking, "how do I cook
dinner using a stove?"
You haven't provided any information on the type of data warehouse you
need to create, where the source data will come from, or how the data
warehouse will be used. All we've been told is that you plan to use DTS,
which is just a tool, not a data warehouse in a box.
If you already do have some background in data warehousing, follow up
with a detailed description of where you're at and where you want to go, and
people here will be able to provide you with much more constructive ideas.
If you don't have any background yet, you need to start doing some reading.
Get the Kimball book, read the sections in BOL, and figure out exactly how
data warehousing will -- or will not -- help your situation.|||Please refer this website as guildeline
http://www.microsoft.com/sql/evaluation/bi/default.asp
"supernova" <abc@.yahoo.com> wrote in message
news:e$hschKiEHA.1384@.TK2MSFTNGP10.phx.gbl...
> Thanks for the advice. Can you please give me an idea first?
>
> "Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
> news:eFC3JnJiEHA.1356@.TK2MSFTNGP09.phx.gbl...
>> In addition to what Dejan Sarka posted, you might want to get a book on
> data
>> warehousing... I highly recommend Ralph Kimballs _Data Warehouse Toolkit_
> as
>> a starting point.
>>
>> "supernova" <abc@.yahoo.com> wrote in message
>> news:OY3dYEFiEHA.2916@.TK2MSFTNGP12.phx.gbl...
>> > How do you implement data warehouse using DTS in SQL 2000 server?
>> >
>> >
>>
>