Hands-On Microsoft SQL Server™ 2005 Integration Services (Database & ERP - OMG)

3 avg rating
( 7 ratings by Goodreads )
 
9780072263190: Hands-On Microsoft SQL Server™ 2005 Integration Services (Database & ERP - OMG)

In-depth coverage of Microsoft’s powerful new data integration tool

Learn to maximize the features of SQL Server 2005 Integration Services from this essential guide. Hands-On Microsoft SQL Server 2005 Integration Services makes learning SSIS easy through the use of extensive real-world exercises structured around every component within the tool. You will learn to collect corporate data from various sources and transform that data for analysis, mining, and reporting.

"synopsis" may belong to another edition of this title.

From the Back Cover:

Build robust, high-performance Business Intelligence solutions with SSIS

Extract, transform, and consolidate data from disparate sources and move it to single or multiple destinations using SQL Server 2005 Integration Services -- the next-generation data integration platform. Hands-On Microsoft SQL Server 2005 Integration Services shows you, step-by-step, how to build and manage SSIS packages, draw out meaningful information from raw data, and deliver de-duplicated and cleansed data to business applications and corporate reports. Inside, you'll get detailed information on migrating to SQL Server 2005 Integration Services, enhancing performance, and implementing encryption policies to secure SSIS packages.

ESSENTIAL SKILLS FOR DATABASE PROFESSIONALS:

  • Build packages with the SSIS Import and Export Wizard and BIDS
  • Create expressions using variables, functions, and operators
  • Lay out package workflow with Control Flow Containers and tasks
  • Secure SSIS packages and encrypt sensitive data
  • Monitor and audit runtime events using log providers
  • Respond to external triggers with event handlers
  • Transform and manipulate input using Data Flow Components
  • Standardize, de-duplicate, and cleanse data with Fuzzy Lookup and Fuzzy Grouping transformations
  • Load Data warehouse using Slowly Changing Dimension transformation
  • Deploy, optimize, troubleshoot, and debug SSIS packages

About the Author:

Ashwani Nanda develops and maintains marketing, analytical, and CRM-based database systems for medium- to large-sized enterprises. His current area of specialization is data modeling, database management, data analysis, and visualization. He started his career on the real-time mainframe systems back in the age when hard disks used to weigh a kilo per megabyte. Moving from system engineering for mainframes to networking and infrastructure support and currently to data practice, he has worked for several major hardware and software vendors. He has loved to network and integrate disparate technologies, with particular attention to productivity and security. These days he is using his integration skills with RDBMS databases and end-user tools. He can be reached at ananda@AffordingIT.co.uk.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Nanda, Ashwani
Published by McGraw-Hill Education
ISBN 10: 0072263199 ISBN 13: 9780072263190
New PAPERBACK Quantity Available: 1
Seller
Your Online Bookstore
(Houston, TX, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education. PAPERBACK. Book Condition: New. 0072263199 Ships promptly. Bookseller Inventory # HDT8881.2CRLVSG100614H1739B

More Information About This Seller | Ask Bookseller a Question

Buy New
5.35
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

2.

Ashwani Nanda
ISBN 10: 0072263199 ISBN 13: 9780072263190
New Quantity Available: 1
Seller
Castle Rock
(Pittsford, NY, U.S.A.)
Rating
[?]

Book Description Book Condition: Brand New. Book Condition: Brand New. Bookseller Inventory # 97800722631901.0

More Information About This Seller | Ask Bookseller a Question

Buy New
9.99
Convert Currency

Add to Basket

Shipping: 3.06
Within U.S.A.
Destination, Rates & Speeds

3.

Ashwani Nanda
Published by McGraw-Hill Education 01/10/2006 (2006)
ISBN 10: 0072263199 ISBN 13: 9780072263190
New Quantity Available: 1
Seller
AwesomeBooks
(Wallingford, United Kingdom)
Rating
[?]

Book Description McGraw-Hill Education 01/10/2006, 2006. Book Condition: NEW. - Brand new item sourced directly from publisher. Packed securely in tight packaging to ensure no damage. Shipped from warehouse on same/next day basis. Bookseller Inventory # 1111-9780072263190

More Information About This Seller | Ask Bookseller a Question

Buy New
11.03
Convert Currency

Add to Basket

Shipping: 3.20
From United Kingdom to U.S.A.
Destination, Rates & Speeds

4.

Ashwani Nanda
Published by McGraw-Hill Education (2006)
ISBN 10: 0072263199 ISBN 13: 9780072263190
New Paperback First Edition Quantity Available: 1
Seller
Irish Booksellers
(Rumford, ME, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education, 2006. Paperback. Book Condition: New. book. Bookseller Inventory # 0072263199

More Information About This Seller | Ask Bookseller a Question

Buy New
18.15
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

5.

Ashwani Nanda
Published by McGraw-Hill Osborne Media (2006)
ISBN 10: 0072263199 ISBN 13: 9780072263190
New Paperback Quantity Available: 1
Seller
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Osborne Media, 2006. Paperback. Book Condition: New. 1. Bookseller Inventory # DADAX0072263199

More Information About This Seller | Ask Bookseller a Question

Buy New
22.67
Convert Currency

Add to Basket

Shipping: 3.06
Within U.S.A.
Destination, Rates & Speeds

6.

Ashwani Nanda
Published by McGraw-Hill Osborne Media (2006)
ISBN 10: 0072263199 ISBN 13: 9780072263190
New Paperback Quantity Available: 1
Seller
Revaluation Books
(Exeter, United Kingdom)
Rating
[?]

Book Description McGraw-Hill Osborne Media, 2006. Paperback. Book Condition: Brand New. 1st edition. 570 pages. 9.00x7.50x1.25 inches. In Stock. Bookseller Inventory # 0072263199

More Information About This Seller | Ask Bookseller a Question

Buy New
44.07
Convert Currency

Add to Basket

Shipping: 6
From United Kingdom to U.S.A.
Destination, Rates & Speeds

7.

Nanda, Ashwani
Published by McGraw-Hill Education
ISBN 10: 0072263199 ISBN 13: 9780072263190
New PAPERBACK Quantity Available: 1
Seller
Cloud 9 Books
(Wellington, FL, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education. PAPERBACK. Book Condition: New. 0072263199 New Condition. Bookseller Inventory # NEW6.0030219

More Information About This Seller | Ask Bookseller a Question

Buy New
47.43
Convert Currency

Add to Basket

Shipping: 3.83
Within U.S.A.
Destination, Rates & Speeds