dts datawarehouse

I want to know more about datawarehouse using dts to implement. Can anyone
give me some resources? Thanks.
Allen,
Here are some:
- Books OnLine
- DTS and Datawarehouse groups here
- http://www.tomchester.net/
- http://www.rkimball.com/html/articles.html
- many books, like Professional SQL Server 2000 DTS (Data Transformation
Services) (Programmer to Programmer)
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
""Allen Iverson"" <no_spam@.bk.com> wrote in message
news:uHmn8JahEHA.3476@.tk2msftngp13.phx.gbl...
> I want to know more about datawarehouse using dts to implement. Can anyone
> give me some resources? Thanks.
>
|||Please read this:
http://msdn.microsoft.com/library/de...l_dwdesign.asp
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in
message news:esJ3uSbhEHA.3076@.tk2msftngp13.phx.gbl...
> Allen,
> Here are some:
> - Books OnLine
> - DTS and Datawarehouse groups here
> - http://www.tomchester.net/
> - http://www.rkimball.com/html/articles.html
> - many books, like Professional SQL Server 2000 DTS (Data Transformation
> Services) (Programmer to Programmer)
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> ""Allen Iverson"" <no_spam@.bk.com> wrote in message
> news:uHmn8JahEHA.3476@.tk2msftngp13.phx.gbl...
>
sql

dts datawarehouse

I want to know more about datawarehouse using dts to implement. Can anyone
give me some resources? Thanks.Allen,
Here are some:
- Books OnLine
- DTS and Datawarehouse groups here
- http://www.tomchester.net/
- http://www.rkimball.com/html/articles.html
- many books, like Professional SQL Server 2000 DTS (Data Transformation
Services) (Programmer to Programmer)
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
""Allen Iverson"" <no_spam@.bk.com> wrote in message
news:uHmn8JahEHA.3476@.tk2msftngp13.phx.gbl...
> I want to know more about datawarehouse using dts to implement. Can anyone
> give me some resources? Thanks.
>|||Please read this:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_dwdesign.asp
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:esJ3uSbhEHA.3076@.tk2msftngp13.phx.gbl...
> Allen,
> Here are some:
> - Books OnLine
> - DTS and Datawarehouse groups here
> - http://www.tomchester.net/
> - http://www.rkimball.com/html/articles.html
> - many books, like Professional SQL Server 2000 DTS (Data Transformation
> Services) (Programmer to Programmer)
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> ""Allen Iverson"" <no_spam@.bk.com> wrote in message
> news:uHmn8JahEHA.3476@.tk2msftngp13.phx.gbl...
>> I want to know more about datawarehouse using dts to implement. Can
>> anyone
>> give me some resources? Thanks.
>>
>

dts datawarehouse

I want to know more about datawarehouse using dts to implement. Can anyone
give me some resources? Thanks.Allen,
Here are some:
- Books OnLine
- DTS and Datawarehouse groups here
- http://www.tomchester.net/
- http://www.rkimball.com/html/articles.html
- many books, like Professional SQL Server 2000 DTS (Data Transformation
Services) (Programmer to Programmer)
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
""Allen Iverson"" <no_spam@.bk.com> wrote in message
news:uHmn8JahEHA.3476@.tk2msftngp13.phx.gbl...
> I want to know more about datawarehouse using dts to implement. Can anyone
> give me some resources? Thanks.
>|||Please read this:
dwdesign.asp" target="_blank">http://msdn.microsoft.com/library/d...>
dwdesign.asp
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:esJ3uSbhEHA.3076@.tk2msftngp13.phx.gbl...
> Allen,
> Here are some:
> - Books OnLine
> - DTS and Datawarehouse groups here
> - http://www.tomchester.net/
> - http://www.rkimball.com/html/articles.html
> - many books, like Professional SQL Server 2000 DTS (Data Transformation
> Services) (Programmer to Programmer)
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> ""Allen Iverson"" <no_spam@.bk.com> wrote in message
> news:uHmn8JahEHA.3476@.tk2msftngp13.phx.gbl...
>

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...
>
|||"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...
> data
> as
>
|||And why do you want to use dts?
Nigel Rivett
www.nigelrivett.net
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

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...
>|||"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...
> data
> as
>|||And why do you want to use dts?
Nigel Rivett
www.nigelrivett.net
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

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?
>> >
>> >
>>
>