Microsoft SQL Server 2000 Data Transformation Services

Overview
PART I Getting Started with DTS
1 A Quick Look at DTS 5
2 DTS Enhancements for SQL Server 2000 41
3 DTS and the Flow of Data Through the Enterprise 59
4 Using DTS to Move Data into a Data Mart 77
PART II DTS Connections and the Data Transformation Tasks
5 DTS Connections 101
6 The Transform Data Task 125
7 Writing ActiveX Scripts for a Transform Data Task 179
8 The Data Driven Query Task 213
9 The Multiphase Data Pump 227
The Parallel Data Pump Task 247
10
PART III Other Data Movement and Manipulation Tasks
11 The Bulk Insert Task 267
12 The Execute SQL Task 291
13 The Copy SQL Server Objects Tasks 309
14 The File Transfer Protocol (FTP) Task 325
15 The Transfer Database and Other Transfer Tasks 333
PART IV Control Tasks
16 Writing Scripts for an ActiveX Script Task 345
17 The Dynamic Properties Task 365
18 The Execute Package Task 377
19 The Message Queue Task 391
The Send Mail Task 405
20
21 The Analysis Services Tasks 411
22 The Execute Process Task 425
PART V DTS Packages and Steps
23 The DTS Package and Its Properties 435
24 Steps and Precedence Constraints 469
25 Rapid Development with the Copy Database Wizard and the DTS Impot/Export
Wizard 501
26 Managing Packages with Visual Basic and Stored Procedures 525
27 Handling Errors in a Package and Its Transformations 553
28 High-Performance DTS Packages 565
29 Integrating DTS with Meta Data Services 587
PART VI Extending the Power of DTS
30 Programming with the DTS Object Model 611
31 Creating a Custom Task in VB 633
32 Creating a Custom Transformation with VC++ 659
Index 679

Another Microsoft Books
Another Database Books
Download