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.

Expert authors bring new life to this UNIX text by using an approach that gives people a new understanding of the system itself. This is the most up-to-date information presented by experts who are in the trenches on a daily basis, and want to provide the most practical and relevant information.

This book appeals to both developers and database administrators who are faced with the common situation of having to migrate or integrate data from one location into another. While the first section of the book is designed for the beginner to DTS, it is assumed that the reader has at least basic database and programming experience. The second section is extensive coding, and is best used by someone with intermediate to advanced programming skills. The third section contains a mix of examples that will be useful to all levels of database administrators and programmers. For the readers who have been using DTS this section can be used as a reference section and help with DTS designs and usage. Unlike other resources available, this book covers data transformation in both SQL Server 7 and 2000.

Defense Transportation: Algorithms, Models and Applications for the 21st Century contains papers divided into three general sections according to the title of this text: algorithms, models, and applications. The first section on algorithms contains papers that are theoretical in nature or contain new techniques that relate to Defense Transportation System (DTS) processes. A sampling of the papers contained in this section deals with group theoretic "tabu" search techniques, shortest path sailing distance algorithms, and strategic airlift model validation methods. The second section contains papers on various transportation models used throughout the DoD and transportation industry, as well as some newly developed transportation modelling methods that may eventually find their way into larger scale transportation models. A review of the major strategic mobility models is also contained in this section. The third section contains papers on various transportation applications that have been used to support various DTS studies and analyses. This section also contains a diverse set of topics, with articles ranging from a paper on North Atlantic Treaty Organization (NATO) strategic lift requirements to an analysis paper on theater reception, staging, onward movement, and integration. Preface by General John W. Handy, Commander, United States Transportation Command Focus on land, sea, and air transportation models and methods Manuscripts written by analysts and researchers active in the field and directly supporting the United States Defense Transportation System Research methods were instrumental in defining the in-place DTS that so efficiently deployed forces for Operation Enduring Freedom and Operation Iraqi Freedom