Can anyone recommend a good beginners book for learning the fundementals of DTS ?

Question

Post reply

Can anyone recommend a good beginners book for learning the fundementals of DTS ?

Leeland

SSCrazy Eights

Points: 8959
More actions
July 6, 2005 at 12:45 pm

#60776

I have worked with query analyzer for roughly a year and learned some interesting techniques from a co-worker of mine who is a genius with programming. Recently he started showing me some stuff with DTS and I found that to be extremely interesting !!!

So I am looking for a decent book that will show me the ropes and explain how DTS's work and the proper way to set them up.

I did some searching on Amazon but didn't find what I was looking for...so if anyone could give me a reference to a decent book or site I would appreciate it.

Thanks in advance

Leeland

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

DSP-120308 Hall of Fame Points: 3959 More actions · Answer 1

I don't have a good book to recommend (at least not yet ) but here is a good site to start with:

http://www.sqldts.com/

jmcgarvey Default port Points: 1489 More actions · Answer 2

Microsoft SQL Server 2000 DTS by Timothy Peterson. Also look in Books On Line.

dm Ten Centuries Points: 1135 More actions · Answer 3

Take a look at Professional SQL Server 2000 DTS:

http://www.amazon.com/exec/obidos/tg/detail/-/0764543687/qid=1120679330/sr=1-1/ref=sr_1_1/102-2634227-9118521?v=glance&s=books

My copy is well used

Diane

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 4

Take a look at Professional SQL Server 2000 DTS

And it is co-authored by SQL Server Central co-founder, Brian Knight.

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

philcart SSC-Forever Points: 47794 More actions · Answer 5

You should also take a look at this best practices article,

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_busintbpwithdts.asp

Some of it is specific to Analysis Services, but the DTS parts are worth their weight in gold.

--------------------
Colt 45 - the original point and click interface

Leeland SSCrazy Eights Points: 8959 More actions · Answer 6

Thanks guys for the plentiful replies, I will take a closer look at the tomorrow when I am at work.

Thanks again,

Leeland

Bob McEuen Right there with Babe Points: 791 More actions · Answer 7

I can definitely recommend Professional SQL Server 2000 DTS, a collaborative effort of Chaffin, Knight and Robinson.

It has been a tremendous resource for me.

I don't know what your plans are for SQL2005, but as I am sure you are aware the DTS technology is being replaced by a more comprehensive technology, SSIS, which will require a substantial learning curve. You might want to consider checking out the June Community Technology Preview of SQL2005 if it will be in your near future. Might keep you from having to learn two technologies.

Bob McEuen

Leeland SSCrazy Eights Points: 8959 More actions · Answer 8

I will have to look into that SSIS and read up on it...thanks for the info