Tags
Language
Tags
March 2024
Su Mo Tu We Th Fr Sa
25 26 27 28 29 1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31 1 2 3 4 5 6

Microsoft® SQL Server™ 2000 DTS Step by Step [Repost]

Posted By: ChrisRedfield
Microsoft® SQL Server™ 2000 DTS Step by Step [Repost]

Carl Rabeler - Microsoft® SQL Server™ 2000 DTS Step by Step
Published: 2003-09-24 | ISBN: 0735619166 | CHM | 464 pages | 29 MB


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
About DTS in SQL Server 2000:
Microsoft SQL Server 2000 Data Transformation Services (DTS) provides a set of graphical tools and programmable objects to extract, transform, and consolidate data from disparate sources into single or multiple destinations. By using DTS tools, you can create custom data movement solutions to support decision-making, improve system performance, upgrade existing systems, and more.