Poetry Madness
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    The Powell's Playlist | March 13, 2015

    Kent Russell: IMG Kent Russell's Playlist for I Am Sorry to Think I Have Raised a Timid Son



    I don't listen to music while I write. Frankly, I don't see how anyone can. Since all style is rhythm, and since I cannot write anything that's as... Continue »

    spacer

Microsoft SQL Server 2000 DTS Step by Step with CDROM (Step by Step)

by

Microsoft SQL Server 2000 DTS Step by Step with CDROM (Step by Step) Cover

 

Out of Print

Synopses & Reviews

Publisher Comments:

Teach yourself how to use SQL Server 2000 Data Transformation Services (DTS)—and begin writing your own data movement applications—one step at a time. This practical, hands-on tutorial expertly guides you through the development of a DTS application that extracts and transforms data from a database into a data warehouse. Work at your own pace through the easy-to-follow lessons and hands-on exercises to master essential techniques. And accelerate your productivity by working with instructive code examples and best practices for SQL Server 2000 DTS.

Discover how to: Create simple data movement packages with the DTS Import/Export Wizard Create a complex data movement application with the DTS Designer that configures pre-built DTS tasks Exploit the flexibility of the Data Driven Query (DDQ) task without sacrificing performance Incorporate execution logic, flow control, branching, transaction control, and parallel execution into DTS packages and tasks Dynamically configure DTS packages and tasks at run time Save DTS packages in SQL Server, Meta Data Services, Structured Storage, and Microsoft Visual Basic® file formats Extract and transform heterogeneous data using ActiveX® Scripts Integrate customized logging, error handling, and batch control into your application Deploy and operate a data movement application

About DTS in SQL Server 2000:

Microsoft SQL Server 2000 Data Transformation Services (DTS) provides a set of graphical tools and programmable objects to extract, transform, and consolidate data from disparate sources into single or multiple destinations. By using DTS tools, you can create custom data movement solutions to support decision-making, improve system performance, upgrade existing systems, and more.

CD features: Practice files for all the book’s procedures

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

Book News Annotation:

This introduction to SQL server 2000 data transformation services (DTS) walks step-by-step through the procedures for building an extensible data movement application that periodically moves data from delimited text files, an SQL server database, and Excel spreadsheets into a multidimensional cube in Microsoft analysis services. The CD- ROM contains practice files for the procedures.
Annotation 2004 Book News, Inc., Portland, OR (booknews.com)

Synopsis:

Target Audience: Professional database and data warehouse developers

Synopsis:

Teach yourself how to use SQL Server 2000 Data Transformation Services (DTS)—and begin writing your own data movement applications—one step at a time. This practical, hands-on tutorial expertly guides you through the development of a DTS application that extracts and transforms data from a database into a data warehouse. Work at your own pace through the easy-to-follow lessons and hands-on exercises to master essential techniques. And accelerate your productivity by working with instructive code examples and best practices for SQL Server 2000 DTS.

Discover how to:

  • Create simple data movement packages with the DTS Import/Export Wizard
  • Create a complex data movement application with the DTS Designer that configures pre-built DTS tasks
  • Exploit the flexibility of the Data Driven Query (DDQ) task without sacrificing performance
  • Incorporate execution logic, flow control, branching, transaction control, and parallel execution into DTS packages and tasks
  • Dynamically configure DTS packages and tasks at run time
  • Save DTS packages in SQL Server, Meta Data Services, Structured Storage, and Microsoft Visual Basic file formats
  • Extract and transform heterogeneous data using ActiveX Scripts
  • Integrate customized logging, error handling, and batch control into your application
  • Deploy and operate a data movement application

About DTS in SQL Server 2000:

Microsoft SQL Server 2000 Data Transformation Services (DTS) provides a set of graphical tools and programmable objects to extract, transform, and consolidate data from disparate sources into single or multiple destinations. By using DTS tools, you can create custom data movement solutions to support decision-making, improve system performance, upgrade existing systems, and more.

CD features:

  • Practice files for all the book’s procedures

For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

Synopsis:

25-Word Description Teach yourself how to develop a data movement application with SQL Server 2000 Data Transformation Services (DTS)--one step at a time! Discover the full range of DTS capabilities at your own pace through dozens of hands-on exercises and code examples. 75-Word Description Teach yourself the full range of capabilities of SQL Server 2000 Data Transformation Services (DTS)--one step at a time! This practical, hands-on tutorial expertly guides you through the development of a DTS application that extracts and transforms data from a database into a data warehouse. Work at your own pace through easy-to-follow lessons and hands-on exercises to learn essential techniques for performing basic and advanced tasks and for creating custom tasks. You'll learn how to work with heterogeneous data sources to extract, transform, and consolidate data using ActiveX(R) scripts. And you'll learn how to incorporate execution logic, flow control, looping, transaction control, logging, error handling, and security into DTS packages. When you complete the step-by-step lessons, you'll have built a full data movement application. Positioning Statement: Your hands-on, self-study guide to developing applications using SQL Server 2000 Transformation Services

About the Author

Carl Rabeler is an MCT, MCDBA, and MCSE. In conjunction with the Business Intelligence Practices group at Microsoft, Carl authored the technical documentation for the SQL Server Accelerator for Business Intelligence, the DTS Programming Practices Used in SQL Server Accelerator for Business Intelligence white paper, and the Microsoft Analysis Services Performance Guide white paper. Carl also wrote the SQL Server High Availability Series, which is available via MSDN. He also wrote the Microsoft SQL Server 2000 System Administration MCSE Training Kit and the Academic Learning Series course based on that book. Before that, he was a subject matter expert for the Microsoft Official Courseware group from 1995 through 2000, working with both Microsoft SQL Server and Microsoft Exchange Server. Carl has also been an independent software consultant since 1989, developing hardware and software solutions for a variety of customers.

Product Details

ISBN:
9780735619166
Author:
Rabeler, Carl
Publisher:
Microsoft Press
Location:
Redmond, Wash.
Subject:
Client-server computing
Subject:
Database Management - SQL Server
Subject:
Sql server
Subject:
Database Management - General
Subject:
Database design
Copyright:
Edition Description:
Trade Paper
Series:
Pro-Step by Step Developer
Series Volume:
1365
Publication Date:
20030931
Binding:
TRADE PAPER
Language:
English
Illustrations:
Yes
Pages:
464
Dimensions:
23 cm. +

Related Subjects

Computers and Internet » Database » Applications
Computers and Internet » Database » Design
Computers and Internet » Database » SQL
Computers and Internet » Networking » General
Computers and Internet » Software Engineering » Software Management

Microsoft SQL Server 2000 DTS Step by Step with CDROM (Step by Step) Used Trade Paper
0 stars - 0 reviews
$2.25 In Stock
Product details 464 pages Microsoft Press - English 9780735619166 Reviews:
"Synopsis" by , Target Audience: Professional database and data warehouse developers
"Synopsis" by , Teach yourself how to use SQL Server 2000 Data Transformation Services (DTS)—and begin writing your own data movement applications—one step at a time. This practical, hands-on tutorial expertly guides you through the development of a DTS application that extracts and transforms data from a database into a data warehouse. Work at your own pace through the easy-to-follow lessons and hands-on exercises to master essential techniques. And accelerate your productivity by working with instructive code examples and best practices for SQL Server 2000 DTS.

Discover how to:

  • Create simple data movement packages with the DTS Import/Export Wizard
  • Create a complex data movement application with the DTS Designer that configures pre-built DTS tasks
  • Exploit the flexibility of the Data Driven Query (DDQ) task without sacrificing performance
  • Incorporate execution logic, flow control, branching, transaction control, and parallel execution into DTS packages and tasks
  • Dynamically configure DTS packages and tasks at run time
  • Save DTS packages in SQL Server, Meta Data Services, Structured Storage, and Microsoft Visual Basic file formats
  • Extract and transform heterogeneous data using ActiveX Scripts
  • Integrate customized logging, error handling, and batch control into your application
  • Deploy and operate a data movement application

About DTS in SQL Server 2000:

Microsoft SQL Server 2000 Data Transformation Services (DTS) provides a set of graphical tools and programmable objects to extract, transform, and consolidate data from disparate sources into single or multiple destinations. By using DTS tools, you can create custom data movement solutions to support decision-making, improve system performance, upgrade existing systems, and more.

CD features:

  • Practice files for all the book’s procedures

For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

"Synopsis" by , 25-Word Description Teach yourself how to develop a data movement application with SQL Server 2000 Data Transformation Services (DTS)--one step at a time! Discover the full range of DTS capabilities at your own pace through dozens of hands-on exercises and code examples. 75-Word Description Teach yourself the full range of capabilities of SQL Server 2000 Data Transformation Services (DTS)--one step at a time! This practical, hands-on tutorial expertly guides you through the development of a DTS application that extracts and transforms data from a database into a data warehouse. Work at your own pace through easy-to-follow lessons and hands-on exercises to learn essential techniques for performing basic and advanced tasks and for creating custom tasks. You'll learn how to work with heterogeneous data sources to extract, transform, and consolidate data using ActiveX(R) scripts. And you'll learn how to incorporate execution logic, flow control, looping, transaction control, logging, error handling, and security into DTS packages. When you complete the step-by-step lessons, you'll have built a full data movement application. Positioning Statement: Your hands-on, self-study guide to developing applications using SQL Server 2000 Transformation Services
spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.