Microsoft SQL Server(TM) 2000 DTS Step by Step (Step By Step (Microsoft))
|
| |
ISBN |
0735619166 |
|
Release Date |
24 September 2003 |
|
Category |
SQL Server |
|
Tags |
dts, sql, sql server 2000, "sql server", sql server, "step by step", 0735619166, "dts", step by step, step, dts package, microsoft, dts packeges, sql and dts, sqlserver 2000, 2000,
|
|
This book @Amazon |
View |
|
Description
Your step-by-step guide to capturing and transforming data from across the enterprise—and beyond.
Teach yourself how to use SQL Server 2000 Data Transformation Services (DTS)—and begin writing your own data movement applications—one step at a time. This practical, hands-on tutorial expertly guides you through the development of a DTS application that extracts and transforms data from a database into a data warehouse. Work at your own pace through the easy-to-follow lessons and hands-on exercises to master essential techniques. And accelerate your productivity by working with instructive code examples and best practices for SQL Server 2000 DTS.
Discover how to:
- Create simple data movement packages with the DTS Import/Export Wizard
- Create a complex data movement application with the DTS Designer that configures pre-built DTS tasks
- Exploit the flexibility of the Data Driven Query (DDQ) task without sacrificing performance
- Incorporate execution logic, flow control, branching, transaction control, and parallel execution into DTS packages and tasks
- Dynamically configure DTS packages and tasks at run time
- Save DTS packages in SQL Server, Meta Data Services, Structured Storage, and Microsoft Visual Basic® file formats
- Extract and transform heterogeneous data using ActiveX® Scripts
- Integrate customized logging, error handling, and batch control into your application
- Deploy and operate a data movement application
|
Other books on SQL Server
|