Microsoft SQL Server 2000 DTS [Data Transformation Services] - Softcover

Peterson, Timothy

Softcover

ISBN 10: 0672320118 ISBN 13: 9780672320118

Publisher: Sams Publishing, 2000

Synopsis

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.

About this title

About the Author

Timothy Peterson is the chief consultant at SDG Computing, Inc., a company specializing in data warehousing with Microsoft¿s SQL Server tools. He teaches the Microsoft Data Warehousing course and customized DTS and OLAP courses for Mindsharp Learning Centers in Bloomington, MN. He has used DTS in SQL Server 7.0 for data warehousing projects with telecommunications, insurance, manufacturing, and internet companies. Tim was the lead author of Microsoft OLAP Unleashed, published by SAMS in 1999.

From the Back Cover

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.

From the Inside Flap

MASTER DTS CONCEPTS AND BUILD DTS APPLICATIONS:

Use Data Transformation Services (DTS) with a variety of data sources.

Write scripts to customize data transformations

Integrate DTS with XML.

Design data marts and load them with DTS.

Integrate DTS with VB applications.

Use the DTS wizards for rapid development of DTS packages.

Integrate DTS with the OLAP and data mining capabilities of Analysis Services.

Use the transformation tasks, data movement tasks, and control tasks.

Control the flow of events and set up looping in your DTS packages.

Use the multiple phases of the transformation tasks.

Manipulate hierarchical rowsets with the Parallel Data Pump task.

Manage packages with Visual Basic and Transact-SQL stored procedures.

Handle package and transformation errors.

Develop high-performance DTS packages.

Integrate DTS with Meta Data Services.

Create custom tasks in Visual Basic.

Create custom transformations in Visual C++.

Edition details

• Publisher: Sams Publishing
• Publication date: 2000
• Language: English
• ISBN 10: 0672320118
• ISBN 13: 9780672320118
• Binding: Paperback
• Edition number: 1
• Number of pages: 744