|
|
Retail:$49.99
Check Links
For Discounts
Paperback - 744 pages (December 2000) Sams; Dimensions: (in inches):
1.69 x 9.11 x 7.40
|
Timothy Peterson
Data Transformation Services in SQL Server 2000 is a powerful tool for moving
data. DTS is an easy tool to start using. But there is a lot to learn if you want
to take full advantage of the power, the flexibility, and the extensibility of this
data transformation tool. This book can help you learn how to make full use of DTS.
__ Part I contains a variety of topics that help you
get started using DTS in SQL Server 2000. Chapter 1 gives a quick look at DTS. Chapter
2 describes the enhancements made to DTS in moving from SQL Server 7.0 to SQL Server
2000. Chapter 3 describes how DTS can be used to manage the flow of data throughout
an organization. Chapter 4 focuses on the use of DTS to load a star schema in a data
mart.
__ There are extensive VBScript samples, showing how
to use transformation scripts, scripts in ActiveX Script tasks, and workflow scripts.
There are transformation scripts that combine many records into one and one record
into many. There are examples for setting up loops in a DTS package. There are scripts
for documenting the connections in a package, optimizing transformation column references,
setting up package transactions, creating the text of e-mail messages, writing to
text files, and setting DTS properties.
__ The source code for the book can be downloaded from
the publisher's web site.
Keywords: Development: Linux, Java, ASP, CGI, XHTML, interface, scripting, input,
programming, code, (Development), Date published: 04/01/2001
|
