|
 | All orders shipped by airmail!
Click here for our Shipping Policies!
| |
 | | | "In the end, we will remember not the words of our enemies, but the silence of our friends."
- Martin Luther King, Jr. | | | |
|
ZIN Product Number: 10510988 | eBay (last 12 months) | | Auctions: | | 14 | | Price Range: | | $0.04 - 0.09 | | | | Craigslist (last 12 months) | | Classifieds: | | 12 | | Price Range: | | $0.04 - 0.01 | | | | Amazon Used (last 12 months) | | Auctions: | | 90 | | Price Range: | | $0.09 - 0.04 | | | | ZooScape (last 12 months) | | Auctions: | | 0 | | Price Range: | | N/A | | | | | | Google listings (non-affiliate) | | 120 | | MSN listings (non-affiliate) | | 14 | | Yahoo listings (non-affiliate) | | 40 | | |
| | 
 
 | | | |  | | | Product Details
Format: Paperback, 855 pages
Publisher: Wrox Press, Inc.
ISBN: 1861004419
Release Date: Jan 1, 2000
Average Reader Review:     (Based on 1 review.)
| |  | | | In Brief One of the new outstanding features of SQL Server is Data Transformation Services (DTS). DTS can be used by both developers and database administrators (DBAs) and is attracting a lot of interest. There is a demand for information and currently no other books are available to satisfy this. DTS enables data to be moved between a wide variety of sources and destinations, as well as transforming the data along the way to suit your requirements. DTS can be used to maximum effect in data-driven applications, enabling dynamic data transfer across internet and intranet applications. This offers rapid and effective solutions to common problems such as:
Automatically transferring data into data warehouses Importing and exporting data to and from other applications for analysis and reporting Moving working copies of databases between servers
The capabilities of DTS are large and this book will give the reader a complete picture of how to use DTS to its fullest potential.
| | | | From The Publisher Professional SQL Server 2000 DTS follows on from Professional SQL Server 7.0 Programming to drill down into this important and powerful feature of SQL Server 2000. This book begins with a complete introduction to DTS fundamentals and architecture. Building on this introduction we'll take a look at more complex data transformations and security issues involved in moving data between different servers, applications and providers (eg Oracle, DB2, Sybase). The book then focuses on DTS via the DTS object model, which enables developers to incorporate custom transformations and reporting capabilities into their applications. We use examples in both Visual Basic and scripting languages. More advanced topics are then explained including error handling, dynamic data loading, OLAP and Datawarehouses. With code and case studies this book provides a thorough guide to this new upcoming area of SQL Server 2000.
Brian Knight currently writes for SQL Magazine and also has a weekly column at the database website Swynk (www.swynk.com), where he co-runs the SQL Server area. 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.
| |  | | |
 | | | | | Number of Reviews: 1 Average Rating:     
Great detailed book!     
-- Tony Hawthorn, September 5, 2000
| |  | | | Introduction Chapter 1: Welcome to DTS Chapter 2: DTS Fundamentals Chapter 3: Advanced Tasks Chapter 4: Advanced Settings in DTS Chapter 5: Querying Heterogeneous Data Chapter 6: Converting Heterogeneous Data Chapter 7: ActiveX Script Task Fundamentals Chapter 8: Dynamic Configuration of Package Objects Chapter 9: Advanced ActiveX Scripting Chapter 10: Security and DTS Chapter 11: Error Handling Chapter 12: Writing Your Own Custom Tasks Chapter 13: Data Warehouse Loading Chapter 14: Using DTS from Other Applications Chapter 15: Warehouse Data Load Appendix A: Microsoft Data Transformation Services Package Object Library Reference Appendix B: ADO Object Summary Appendix C: Visual Basic Functions and Keywords Appendix D: Variable Naming and Other Code Conventions Appendix E: Microsoft Scripting Run Time Reference
| |  | | | Find similiar books in these subject areas:
All Topics > Computers & Internet > Microsoft > Development > SQL Server All Topics > Computers & Internet > Programming > General All Topics > Computers & Internet > Databases > Database Management Systems All Topics > Computers & Internet > Databases > Specific Databases > SQL > General All Topics > Computers & Internet > Databases > General All Topics > Computers & Internet > General
| | | | People like you also bought:
Professional SQL Server 2000 Programming, by Robert Vieira
SQL Server 2000 Stored Procedure Programming, by
The Microsoft SQL Server 2000 Analysis Services Step by Step, by OLAP Train
Professional SQL Server 2000 XML, by Paul J. Burke
The Guru's Guide to Transact-SQL, by Ken Henderson
Microsoft SQL Server 2000 Data Transformation Services, by Timothy Peterson
The Guru's Guide to SQL Server Stored Procedures, Xml, and HTML with CDROM, by Ken Henderson
MDX Solutions : With Microsoft SQL Server Analysis Services, by George Spofford
| | | | | | Keywords Computer Books: General, Computer Bks - Data Base Management, Computers, Database Management - SQL Server, Database Management - General, Programming Languages - General, Programming Languages - SQL, Database management, Data transmission systems
| |
| | 
 
 | | | |
Make $1 per sale - Link to ZooScape.com! | |