HAPPY BOOKSGIVING
Use code BOOKSGIVING during checkout to save 40%-55% on books and eBooks. Shop now.
Register your product to gain access to bonus material or receive a coupon.
Adobe® Digital Editions software.
This eBook requires the freeBefore downloading this DRM-encrypted PDF, be sure to:
Microsoft SQL Server 2000 Data Transformation Services covers all facets in the development of data transformations with DTS. The reader will learn how to create each of the DTS tasks, both in the User Interface supplied with SQL Server and through the object model using Visual Basic or VBScript.
Microsoft SQL Server 2000 Data Transformation Services is filled with numerous small examples, showing how each of the capabilities of DTS can be used. It also includes a number of Data Transformation Templates, which can be used by the readers to help develop their own packages.
Introduction.
Using DTS in SQL Server 7.0 and SQL Server 2000. The Code Samples. Keeping Current with Information on DTS.
I. GETTING STARTED WITH DTS.
1. A Quick Look at DTS.A High-Performance Data Pump-and a Whole Lot More. Using the DTS Designer to Create Complex Data Transformations.
The Structure of a DTS Package. Creating Connections. Creating Tasks. Setting the Workflow.
Saving and Retrieving DTS Packages.
SQL Server Storage. SQL Server Meta Data Services Storage. Structured Storage File. Visual Basic File. Package Versions.
How to Execute a DTS Package.
From the DTS Designer. From the Wizards. From the Enterprise Manager. From Visual Basic Code. With the OLE Automation System Stored Procedures. As a Data Provider. Using the DTSRun Command Prompt Utility. Using the DTSRun Utility for Windows. From Another DTS Package. Scheduling a DTS Package. The Execution Context for a DTS Package.
Using the DTS Object Model for Programmatic Control.
The DTS Object Model. Using the DTS Object Model with the Dynamic Properties Task. Using the DTS Object Model with Disconnected Edit. Programming DTS with VBScript. Programming DTS with Visual Basic. Programming DTS with VC++.
DTS Templates.
Using Templates. Creating Templates.
Using Wizards for Rapid Application Development.
Copy Database Wizard. DTS Import/Export Wizard.
Practical Uses for DTS.
Upgrading a Database from Microsoft Access to SQL Server. Consolidating Data from Multiple Sources. Initial and Periodic Loading of a Data Mart or a Data Warehouse. Reporting on Data from Transaction Processing Systems. Building an Interface to the Web for a Legacy System. Archiving a Database. Analyzing Internet Clickstream Data. Importing and Exporting with XML.
Conclusion.
2. DTS Enhancements for SQL Server 2000.Top Ten New DTS Features. The New DTS Tasks.
Dynamic Properties Task. The File Transfer Protocol (FTP) Task. The Execute Package Task. The Message Queue Task. The Parallel Data Pump Task. The Analysis Services Processing Task. The Data Mining Prediction Query Task. The Transfer Databases Task. The Transfer Master Stored Procedures Task. The Transfer Jobs Task. The Transfer Logins Task. The Transfer Error Messages Task.
Transformation Task Enhancements.
Multiple Phases in the Data Transformation Tasks. Package Object Browser When Writing Scripts.
The New Data Transformations.
Using Parameters in the Source Query. New Error File Options. Lookups Can Now Modify Data.
New Features in Other Tasks.
Using Input Parameters in the Execute SQL Task. Assigning the Result of the Execute SQL Task to Parameters. Assigning the Result of the