Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Professional SQL Server 2000 DTS (Data Transformation Service)

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

About the Author

He also works as a Sr. SQL Server DBA and spends most of his time deep in DTS and SQL Server.

Todd Robinson (MCP, MCP+I, MCP+SB, MCSE, MCSE+I, MCSD, MCDBA, MCT, CCNA) lives in Atlanta, GA where he is an internet application developer and data warehousing guru for Metlife. He specializes in MTS/COM+, ASP, XML, SQL Server and related Windows DNA technologies. In addition to his normal job duties at Metlife, he is President of GradesNow.com an internet application service for teachers, students and parents to allow access to grades online.

(HTML tags aren't allowed.)

Wicked Cool Shell Scripts
Wicked Cool Shell Scripts

This cookbook of useful, customizable, and fun scripts gives you the tools to solve common Linux, Mac OS X and UNIX problems and personalize your computing environment.

The UNIX shell is the main scripting environment of every Linux, Mac OS X and UNIX system, whether a rescued laptop or a million-dollar mainframe. This cookbook of...

Essential Check Point FireWall-1 NG: An Installation, Configuration, and Troubleshooting Guide
Essential Check Point FireWall-1 NG: An Installation, Configuration, and Troubleshooting Guide
Now there's a definitive insider's guide to planning, installing, configuring, and maintaining the newest version of the world's #1 firewall: Check Point™ FireWall-1® Next Generation™. Leading Check Point support authority Dameon Welch-Abernathy (a.k.a. PhoneBoy) offers exclusive hands-on tips, techniques, checklists, and...
Microscale Organic Laboratory with Multistep and Multiscale Syntheses
Microscale Organic Laboratory with Multistep and Multiscale Syntheses

This text is an unbound, binder-ready edition.

This is a laboratory text for the mainstream organic chemistry course taught at both two and four year schools, featuring both microscale experiments and options for scaling up appropriate experiments for use in the macroscale lab. It provides complete coverage of organic

Beginning Java EE 7 (Expert Voice in Java)
Beginning Java EE 7 (Expert Voice in Java)

Java Enterprise Edition (Java EE) continues to be one of the leading Java technologies and platforms. Beginning Java EE 7 is the first tutorial book on Java EE 7.

Step by step and easy to follow, this book describes many of the Java EE 7 specifications and reference implementations, and shows them in action...

Integrating Facebook iOS SDK with Your Application
Integrating Facebook iOS SDK with Your Application

Optimize the social power of your applications by integrating the popular Facebook iOS SDK


  • Effectively promote your Social Applications through Facebook
  • Invite your friends to use your application
  • Learn and understand Facebook iOS features with hands-on examples
  • ...
OSGi in Depth
OSGi in Depth
I started working with OSGi in about 2006. This was back in the days of BEA and Web- Logic. Our goal was a very ambitious one: to create a new application server profiled for a particular vertical market—financial front offices.
The journey has been a long one. But as they say, it is not just about...
©2020 LearnIT (support@pdfchm.net) - Privacy Policy