25 Books to Read Before You Die
 
 

Recently Viewed clear list


Original Essays | Yesterday, 11:30am

Julie Schumacher: IMG Dear Professor Fitger



Saint Paul, August 2014 Dear Professor Fitger, I've been asked to say a few words about you for Powells.com. Having dreamed you up with a ball-point... Continue »
  1. $16.07 Sale Hardcover add to wish list

    Dear Committee Members

    Julie Schumacher 9780385538138

spacer
Qualifying orders ship free.
$2.25
List price: $40.50
Used Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Local Warehouse Database- SQL

More copies of this ISBN

SQL Server Dts (Landmark)

by

SQL Server Dts (Landmark) Cover

 

Synopses & Reviews

Publisher Comments:

This book appeals to both developers and database administrators who are faced with the common situation of having to migrate or integrate data from one location into another.

While the first section of the book is designed for the beginner to DTS, it is assumed that the reader has at least basic database and programming experience. The second section is extensive coding, and is best used by someone with intermediate to advanced programming skills. The third section contains a mix of examples that will be useful to all levels of database administrators and programmers. For the readers who have been using DTS this section can be used as a reference section and help with DTS designs and usage. Unlike other resources available, this book covers data transformation in both SQL Server 7 and 2000.

Book News Annotation:

Explains techniques for using the data transformation services (DTS) that come packaged with the SQL server. The authors describe the components of DTS, building a DTS package with Visual Basic, and building a data warehouse with DTS and analysis services. The final section offers case studies for applying DTS tools, such as custom error logging, creating a custom task, executing a DTS package from a stored procedure, and data lineage.
Annotation c. Book News, Inc., Portland, OR (booknews.com)

About the Author

Jim Samuelson is the Enterprise Data Services Practice Lead for Magenic Technologies in Minneapolis. Jim has over 11 years of experience in Decision Support and Business Intelligence Systems, and currently serves on the Microsoft Business Intelligence Partner Advisory Council.

Jim speaks at local, regional and national events on various database and software development topics. He holds an MBA in Finance and M.I.S, and is a Microsoft Certified Solution Developer (MCSD).

Marcelino Santos, MCSE, MCSD, is a Senior Consultant at Magnenic Technologies. He has over 16 years of experience as a business analys and software developer within the areas of enterprise modeling, strategic business and information systems planning, data and functional modeling, decision tools, business solutions, and systems integration.

Table of Contents

PLEASE PROVIDE

I. DATA TRANSFORMATION SERVICES—THE TOOL.

1. Introduction to Extraction, Transformation and Loading (ETL) Environment.

2. Introduction to Data Transformations Services.

3. DTS Package and Components.

II. AUTOMATING DATA TRANSFORMATION SERVICES.

4. Building a Package from a Visual Basic Application.

5. Interacting with a Package from a Visual Basic Application.

III. USING THE TOOL—PUTTING IT ALL TOGETHER.

6. Error Logging.

7. Interacting with ActiveX components.

8. Managing Distributed Databases with DTS and MSMQ.

9. Replication and DTS.

10. Packages that control other packages.

11. Custom Tasks.

12. Building and Managing a Data Warehouse with DTS.

13. DTS and Data Mining.

14. Executing a DTS Package from a Stored Procedure.

Product Details

ISBN:
9780735711235
Author:
Samuelson, Jim
Author:
Santos, Marcelino
Author:
Samuelson, Jim
Author:
Hughes, S.
Author:
Miller, S.
Author:
Sullivan, Brian
Author:
Santos, M.
Author:
Sullivan, B.
Author:
Hughes, Steve
Publisher:
Sams
Location:
Indianapolis, Ind.
Subject:
Data transmission systems
Subject:
Database Management - General
Subject:
Client-server computing
Subject:
Database Management - SQL Server
Subject:
Sql server
Subject:
Programming Languages - SQL
Subject:
Database-SQL
Subject:
Database design
Copyright:
Edition Number:
1st ed.
Edition Description:
New Riders
Series:
Landmark (New Riders)
Series Volume:
v. 7
Publication Date:
August 2001
Binding:
TRADE PAPER
Grade Level:
General/trade
Language:
English
Illustrations:
Yes
Pages:
512
Dimensions:
9.03x7.08x1.10 in. 1.72 lbs.

Related Subjects

» Computers and Internet » Database » Applications
» Computers and Internet » Database » Design
» Computers and Internet » Database » SQL
» Computers and Internet » Software Engineering » Software Management

SQL Server Dts (Landmark) Used Trade Paper
0 stars - 0 reviews
$2.25 In Stock
Product details 512 pages Sams - English 9780735711235 Reviews:
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.