Professional SQL Server 2000 DTS -- About the Authors -- Table of Contents -- Introduction -- Who Should Read this Book -- How to Get the Most from this Book -- What's Covered in this Book -- Conventions Used -- Customer Support -- Chapter 1: Welcome to DTS -- The Next Generation in Database Solutions -- The DTS Package -- What's New in 2000? -- The DTS Toolbox -- A Note About NT Authentication Security -- Summary -- Chapter 2: DTS Fundamentals -- DTS Designer -- Tasks Available in SQL Server 2000 -- Creating a DTS Package -- Logging DTS Activity -- Global Variables -- The Bulk Insert Task -- The Execute Process Task -- The Execute SQL Task -- The Copy SQL Server Objects Task -- The Send Mail Task -- The Transfer Error Messages Task -- The Transfer Databases Task -- The Transfer Master Stored Procedures Task -- The Transfer Jobs Task -- The Transfer Logins Task -- DTS Interoperability -- Developer Samples -- Summary -- Chapter 3: Advanced Tasks -- The Multiphase Data Pump -- Data Driven Query (DDQ) -- Dynamic Properties Task -- File Transfer Protocol Task -- Execute Package Task -- Message Queue Task -- Summary -- Chapter 4: Advanced Settings in DTS -- Advanced Package Options -- General Package Properties -- Transform Data Task Options -- Data Scrubbing -- DTS Lookup -- Common Errors -- Summary -- Chapter 5: Querying Heterogeneous Data -- Heterogeneous Data -- Adding a Linked Server -- Using Linked Servers -- Linked Server Limitations -- Summary -- Chapter 6: Converting Heterogeneous Data -- Pre-Conversion Checklist -- Converting Data From Excel -- Converting DB2 Databases -- Single Threaded OLE DB Providers -- Summary -- Chapter 7: ActiveX Script Task Fundamentals -- The Role of ActiveX Scripts in DTS -- Basic Programming Terminology in DTS -- Summary -- Chapter 8: Dynamic Configuration of Package Objects -- DTS Object Model.

Developing with the Object Model -- Using the Dynamic Properties Task -- Summary -- Chapter 9: Advanced ActiveX Scripting -- Global Variables -- The FileSystemObject Object -- The Package as an Object -- Other Helpful Objects Models in DTS -- Summary -- Chapter 10: DTS Security -- Locking down the msdb Database -- DTS Password Protection -- Meta Data Services -- Auditing with the Microsoft Meta Data Services -- Backing Up Your Databases -- Summary -- Chapter 11: Error Handling -- DTS Errors -- Package-Level Auditing and Error Handling -- Task Object Error Handling -- Error Handling from External Applications -- Design Considerations for Optimal Error Handling -- Chapter 12: Writing Your Own Custom Tasks -- What is a Custom Task? -- Why Use a Custom Task? -- The Task Object Model -- Building Your First Custom Task -- More About Custom Tasks -- How DTS Uses a Custom Task -- Building a Complex Custom Task -- Debugging a Custom Task -- Summary -- Chapter 13: Data Warehouse Loading -- Data Warehousing Basics and Terminology -- Creating a Dimensional Data Model -- Creating a Solid ETL Design -- From Source to Stage -- From Stage to Warehouse -- Integrating Analysis Services -- Summary -- Chapter 14: Using DTS from Other Applications -- Application Overview -- Data Services -- Business Services -- User Services -- Putting It All Together -- Chapter 15: Warehouse Data Load -- The Northwind Dimensional Data Model -- The Northwind Staging Area Data Model -- The Northwind ETL Auditing Data Model -- Populating Default Values -- Microsoft Analysis Services -- Designing the ETL Workflow -- Answering Northwind's Business Questions -- Summary -- Appendix A: Microsoft Data Transformation Services Package Object Library Reference -- Objects -- Collections -- ActiveScriptTask -- BulkInsertTask -- Column -- Columns -- Connection -- Connections -- CreateProcessTask.

CustomTask -- CustomTaskUI -- DataDrivenQueryTask -- DataDrivenQueryTask2 -- DataPumpTask -- DataPumpTask2 -- DynamicPropertiesTask -- DynamicPropertiesTaskAssignment -- DynamicPropertiesTaskAssignments -- ExecuteSQLTask -- ExecuteSQLTask2 -- GlobalVariable -- GlobalVariables -- IDTSStdObject -- Lookup -- Lookups -- OleDBProperties -- OleDBProperty -- OleDBProperty2 -- Package -- Package2 -- PackageInfo -- PackageInfos -- PackageLineage -- PackageLineages -- PackageLog -- PackageLogRecord -- PackageLogRecords -- PackageRepository -- PackageSQLServer -- ParallelDataPumpTask -- PersistPropertyBag -- PrecedenceConstraint -- PrecedenceConstraints -- Properties -- PropertiesProvider -- Property -- PropertyBag -- SavedPackageInfo -- SavedPackageInfos -- ScriptingLanguageInfo -- ScriptingLanguageInfos -- SendMailTask -- Step -- Step2 -- StepLineage -- StepLineages -- StepLogRecord -- StepLogRecords -- Steps -- Task -- Tasks -- TransferObjectsTask -- TransferObjectsTask2 -- Transformation -- Transformation2 -- TransformationInfo -- TransformationInfos -- Transformations -- TransformationSet -- TransformationSets -- Global Constants -- Appendix B: ADO Object Summary -- Microsoft ActiveX Data Objects 2.6 Library Reference -- Appendix C: Visual Basic Functions and Keywords -- Operators -- Appendix D: Variable Naming and Other Code Conventions -- Appendix E: Microsoft Scripting Run-time Reference -- Index.