Professional SQL Server 2000 Dts

by Knight, Brian

• ISBN13: 9781861004413
• ISBN10: 1861004419
• Edition: 1st
• Format: Trade Paper
• Copyright: 2000-01-01
• Publisher: Peer Information

Summary

A guide for database programmers and administrators with a working knowledge of SQL servers who would like to learn to create a transactional system to transfer data to and from a wide variety of sources. This text covers all of the basics and may be of use to managers and project managers who want to see how DTS could benefit their business.

Table of Contents

Introduction	1	(6)
Welcome to DTS	7	(40)
DTS Fundamentals	47	(54)
Advanced Tasks	101	(52)
Advanced Settings in DTS	153	(54)
Querying Heterogeneous Data	207	(28)
Converting Heterogeneous Data	235	(30)
ActiveX Script Task Fundamentals	265	(30)
Dynamic Configuration of Package Objects	295	(40)
Advanced ActiveX Scripting	335	(32)
Security and DTS	367	(34)
Error Handling	401	(30)
Writing Your Own Custom Tasks	431	(44)
Data Warehouse Loading	475	(28)
Using DTS from Other Applications	503	(38)
Warehouse Data Load	541	(144)
Appendix A: Microsoft Data Transformation Services Package Object Library Reference	685	(56)
Appendix B: ADO Object Summary	741	(20)
Appendix C: Visual Basic Functions and Keywords	761	(58)
Appendix D: Variable Naming and Other Code Conventions	819	(4)
Appendix E: Microsoft Scripting Run Time Reference	823	(12)
Index	835