Join Amazon Prime and get unlimited Free One-Day Delivery. Already a member? Sign in.

 

or
Sign in to turn on 1-Click ordering.
 
   
More Buying Choices
34 used & new from £15.00

Have one to sell? Sell yours here
 
   
Professional SQL Server 2000 DTS (Data Transformation Services) (Programmer to Programmer)
 
 

Professional SQL Server 2000 DTS (Data Transformation Services) (Programmer to Programmer) (Paperback)

by Mark Chaffin (Author), Brian Knight (Author), Todd Robinson (Author) "DTS - not just another pretty acronym ..." (more)
2.2 out of 5 stars See all reviews (6 customer reviews)
RRP: £35.99
Price: £30.59 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £5.40 (15%)
In stock.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.

Only 1 left in stock--order soon (more on the way).

Want guaranteed delivery by Wednesday, July 8? Choose Express delivery at checkout. See Details
23 new from £22.68 11 used from £15.00
Other Editions: RRP: Our Price: Other Offers:
Paperback (1st) 2 used & new from £19.95

Frequently Bought Together

Customers buy this book with Microsoft SQL Server 2005: A Beginner's Guide by Dusan Petkovic

Professional SQL Server 2000 DTS (Data Transformation Services) (Programmer to Programmer) + Microsoft SQL Server 2005: A Beginner's Guide
Price For Both: £50.13

Show availability and shipping details


Customers Who Bought This Item Also Bought

Microsoft® SQL Server™ 2000 DTS Step by Step (Step by Step (Microsoft))

Microsoft® SQL Server™ 2000 DTS Step by Step (Step by Step (Microsoft))

by Carl Rabeler
£31.96
Professional SQL Server 2005 Integration Services

Professional SQL Server 2005 Integration Services

by Brian Knight
4.0 out of 5 stars (3)  £20.79
Inside Microsoft® SQL Server™ 2005: T-SQL Querying (Solid Quality Learning)

Inside Microsoft® SQL Server™ 2005: T-SQL Querying (Solid Quality Learning)

by Lubor Kollar, Dejan Sarka Itzik Ben-Gan (Solid Quality Learning)
4.8 out of 5 stars (10)  £23.07
Professional SQL Server Analysis Services 2005 with MDX (Programmer to Programmer)

Professional SQL Server Analysis Services 2005 with MDX (Programmer to Programmer)

by Sivakumar Harinath
2.3 out of 5 stars (3)  £20.79
Explore similar items

Product details

  • Paperback: 888 pages
  • Publisher: John Wiley & Sons; New edition edition (14 Jul 2000)
  • Language English
  • ISBN-10: 0764543687
  • ISBN-13: 978-0764543685
  • Product Dimensions: 22.2 x 18.2 x 4.8 cm
  • Average Customer Review: 2.2 out of 5 stars See all reviews (6 customer reviews)
  • Amazon.co.uk Sales Rank: 441,648 in Books (See Bestsellers in Books)

    Popular in these categories:

    #46 in  Books > Computing & Internet > Microsoft Windows > Programming > SQL Server
    #47 in  Books > Computing & Internet > Databases > Applications > Microsoft SQL Server > Advanced & Intermediate
  • See Complete Table of Contents

Customers Viewing This Page May Be Interested in These Sponsored Links

  (What is this?)
Data transformation
   www.trilliumsoftware.com    Streamline your ETL processes and improve data migrations. Free WP 
Sql Server 2000
   www.rackspace.co.uk/databasehosting    Fast, secure SQL hosting. Award winning support 24/7. 
Optimize SQL Server 2000
   www.Confio.com    Instant Optimization of SQL Server, Save on Costs, Free Trial Download! 
  
 

Product Description

Product Description
What is this book about?

(DTS) Data Transformation Services helps you create a transactional system to load and transform your data from and to a wide variety of sources. SQL Server DTS was introduced in the release of SQL Server 7.0; however, SQL Server 2000 sees the functionality and power of this outstanding and incredibly useful tool greatly increased. DTS can be used to maximum effect in data–driven applications, offering rapid and effective solutions to a wide range of common problems.

Professional SQL Server 2000 DTS provides a complete introduction to DTS fundamentals and architecture before exploring the more complex data transformations involved in moving data between different servers, applications, and providers. The book then focuses on DTS programming via the DTS object model, enabling developers to incorporate custom transformations and reporting capabilities into their applications. Advanced topics are explained including error handling, dynamic data loading, and data warehouses. With code and case studies, this book gives the reader a complete picture of how to use DTS to its fullest potential.

What does this book cover?

Here are just a few of the things you′ll find covered in this book:

  • A detailed explanation of the seventeen principal DTS tasks
  • Connecting to, querying, and converting heterogeneous data
  • Dynamic configuration of your DTS packages
  • Enhancing your DTS packages with VBScript and Visual Basic
  • Writing your own custom tasks
  • Using DTS in a data–warehousing environment
  • Employing DTS in other applications

Who is this book for?

This book is principally aimed at database programmers and administrators who have a working knowledge of SQL Server, and who wish to take DTS beyond its most basic level and tailor it to their needs. It will also appeal to managers and project managers who want to gain an understanding of DTS and how it could benefit their businesses.

From the Back Cover
DTS (Data Transformation Services) helps you create a transactional system to load and transform your data from and to a wide variety of sources. SQL Server DTS was introduced in the release of SQL Server 7.0; SQL Server 2000 sees the functionality and power of this outstanding and incredibly useful tool greatly increased. DTS can be used to maximum effect in data–driven applications, offering rapid and effective solutions to a wide range of common problems.

Professional SQL Server 2000 DTS provides a complete introduction to DTS fundamentals and architecture before exploring the more complex data transformations involved in moving data between different servers, applications, and providers. The book then focuses on DTS programming via the DTS object model, enabling developers to incorporate custom transformations and reporting capabilities into their applications. Advanced topics are explained including error handling, dynamic data loading, and data warehouses. With code and case studies, this book gives the reader a complete picture of how to use DTS to its fullest potential.

Who is this book for?

This book is principally aimed at database programmers and administrators who have a working knowledge of SQL Server, and who wish to take DTS beyond its most basic level and tailor it to their needs. It will also appeal to managers and project managers who want to gain an understanding of DTS and how it could benefit their businesses.

What does this book cover?

  • A detailed explanation of the seventeen principal DTS tasks
  • Connecting to, querying, and converting heterogeneous data
  • Dynamic configuration of your DTS packages
  • Enhancing your DTS packages with VBScript and Visual Basic
  • Writing your own custom tasks
  • Using DTS in a data–warehousing environment
  • Employing DTS in other applications



See all Product Description


Inside This Book (Learn More)
First Sentence
DTS - not just another pretty acronym. Read the first page
Explore More
Concordance
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Tag this product

 (What's this?)
Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items.
Your tags: Add your first tag
 

What Do Customers Ultimately Buy After Viewing This Item?

Professional SQL Server 2000 DTS (Data Transformation Services) (Programmer to Programmer)
68% buy the item featured on this page:
Professional SQL Server 2000 DTS (Data Transformation Services) (Programmer to Programmer) 2.2 out of 5 stars (6)
£30.59
Microsoft® SQL Server™ 2000 DTS Step by Step (Step by Step (Microsoft))
32% buy
Microsoft® SQL Server™ 2000 DTS Step by Step (Step by Step (Microsoft))
£31.96

 

Customer Reviews

6 Reviews
5 star:
 (1)
4 star:    (0)
3 star:
 (1)
2 star:
 (1)
1 star:
 (3)
 
 
 
 
 
Average Customer Review
2.2 out of 5 stars (6 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
10 of 10 people found the following review helpful:
1.0 out of 5 stars Do not bother with this book., 24 Jan 2001
Refer to SQL Books Online or SQLDTS.hlp on the SQL Server CD for basic to intermediate help on DTS instead... If you need to know more about programmatical DTS and the DTS Object Model then this book is of no use at all. In fact I have been unable to find a good programmers reference to DTS.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
10 of 10 people found the following review helpful:
2.0 out of 5 stars Not detailed enough to be useful., 21 Dec 2000
By A Customer
This book does a good job of explaining all the things about DTS you could have worked out yourself. However when it comes to anything more advanced like programming with the DTS object model (which is what I wanted the book for inthe first place) the information is very sparse and few examples are provided.

If you want to do anything useful with DTS then don't buy this book. If however you just want to confirm in writing all the obvious features of the graphical interface (already written in the online documentation) then this is for you.

An example of the type of irrelevant stuff which was clearly inserted in this book just to pad it out are the chapter and half dedicated to teaching vbscript from scratch (I suppose we should be grateful the authors didn't put in a description of the entire VB IDE when the got to the custom tasks chapter), and the 100 pages of index's at the back which give no more information then the SQL server books online.

Wrox usually publish excellent technical books, this is a disappointment.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
7 of 7 people found the following review helpful:
1.0 out of 5 stars The book fails to mention several essential pitfalls, 8 Nov 2001
By A Customer
This book guides you through the simple aspects of DTS well. However, this is all it does. It fails to adequately cover the more challenging aspects of DTS. For example, its coverage of the DTS object model is unhelpful and does not begin to explain how it should be deployed as part of a wider solution.

DTS is still a developing technology but some workarounds for common problems would be helpful, such as the various problems to do with moving DTS packages from development to a live environment.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews

5.0 out of 5 stars All you ever wanted to know about DTS
I already realised how powerful DTS is - I use it daily in my job - and how many people realise that you can use SQL Server DTS to convert data from, say, a csv text file into an... Read more
Published on 20 Jul 2005 by Tony W - The A Team

1.0 out of 5 stars Useless book - unless you're Data Warehousing
I got my hands on this book hoping it could help me understand some basic DTS concepts. I had been struggling with some moderately complex DTS packages. Read more
Published on 12 Dec 2002 by MR DANIEL D MATTHEWS

3.0 out of 5 stars Provides good Basic to intermediate understanding of DTS
I bought this Book to enhance my DTS skills. Starts with basic understanding of DTS. Provides good explanation of varius properties of DTS packages and tasks. Read more
Published on 13 Dec 2000 by masoodhnaqvi@hotmail.com

Only search this product's reviews



Customer Discussions

 Beta (What's this?)
This product's forum (0 discussions)
  Discussion Replies Latest Post
  No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
  [Cancel]

   


Listmania!


Look for similar items by category


Look for similar items by subject


Feedback


MCAD/MCSE/MCDBA Self-Paced...

MCAD/MCSE/MCDBA...

Learn how to deliver powerful database solutions using SQL Server 2000... Read more
£48.20 £40.97

Find similar items

 

Make A Wish

Get what you want with an Amazon.co.uk Wish List Make sure you always get what you want with an Amazon.co.uk Wish List.

More info on Wish Lists

 

Up to 50% off Dental Care

Braun Oral-B Professional Care 6000 Rechargeable Toothbrush - Pack of 2
Put a sparkle in your smile with up to 50% off selected Oral-B and Philips rechargeable toothbrushes.

Up to 50% off power toothbrushes

 

Treat Someone

Amazon.co.uk Gift Certificates--available in any amount from £5 to £500 With an Amazon.co.uk Gift Certificate, you can get them what they want (even if you don't know what that is).

Learn more about Gift Certificates

 
Ad

Where's My Stuff?

Delivery and Returns

Need Help?

Your Recent History

  (What's this?)
You have no recently viewed items or searches.

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.

Look to the right column to find helpful suggestions for your shopping session.

Continue Shopping: Top Sellers

amazon.co.uk Amazon Home
International Sites:  United States  |  Germany  |  France  |  Japan  |  Canada  |  China
Business Programs: Sell on Amazon  |  Fulfilment by Amazon  |  Join Associates  |  Join Advantage
Customer Service  |  Help  |  View Basket  |  Your Account
About Amazon.co.uk  |  Careers at Amazon
Conditions of Use & Sale |  Privacy Notice  © 1996-2009, Amazon.com, Inc. and its affiliates