Professional SQL Server 2005 Integration Services
(Sprache: Englisch)
This book will help you get past the initial learning curve quickly so that you can get started using SSIS to transform data, create a workflow, or maintain your SQL Server. Offering you hands-on guidance, you'll learn a new world of integration...
Leider schon ausverkauft
versandkostenfrei
Buch
43.10 €
Produktdetails
Produktinformationen zu „Professional SQL Server 2005 Integration Services “
This book will help you get past the initial learning curve quickly so that you can get started using SSIS to transform data, create a workflow, or maintain your SQL Server. Offering you hands-on guidance, you'll learn a new world of integration possibilities and be able to move away from scripting complex logic to programming tasks using a full-featured language.
What you will learn from this book
* Ways to quickly move and transform data
* How to configure every aspect of SSIS
* How to interface SSIS with web services and XML
* Techniques to scale the SSIS and make it more reliable
* How to migrate DTS packages to SSIS
* How to create your own custom tasks and user interfaces
* How to create an application that interfaces with SSIS to manage the environment
* A detailed usable case study for a complete ETL solution
Who this book is for
This book is for developers, DBAs, and users who are looking to program custom code in all of the .NET languages. It is expected that you know the basics of how to query the SQL Server and have some fundamental programming skills.
Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.
Klappentext zu „Professional SQL Server 2005 Integration Services “
Even seasoned DTS developers will need to relearn how to use the new DTS functions that are part of SQL Server 2005 Integration Services? An author team of well-known experts in the SQL Server world offers best practices in design and development, architectural approaches for reusability, and connectivity to various other popular systems using Integration Services.Presents a detailed description of every new element, new capabilities with control flows and data flows, and a broad discussion of the development environment, data connections, and development paradigms.
Includes full coverage of principal tasks; connecting to, querying, and converting heterogeneous data; and enhancing Integration Services packages with .NET and scripting languages? Demonstrates how to write custom tasks, use Integration Services.
Inhaltsverzeichnis zu „Professional SQL Server 2005 Integration Services “
Foreword.Preface.
Acknowledegements.
Author Bios.
Introduction.
1. Services.
2. Importing and Exporting Data.
3. SSIS Fundamentals.
4. Data Flow Elements and Transforms.
5. Creating Your First Package.
6. Advanced Tasks and Transforms.
7. Scripting in DTS.
8. Accessing Heterogenous Data.
9. Reliability and Scalability.
10. Understanding the Integration Services Engine.
11. Applying the Integration Services Engine.
12. DTS 2000 Migration and Metadata Management.
13. Error and Event Handling.
14. Programming and Extending SSIS.
15. Adding a User Interface to Components.
16. External Management and WMI.
17. Using SSIS with External Applications.
18. SSIS Software Development Life Cycle.
19. Case Study: Typical Relational ETL.
Index.
Autoren-Porträt von Brian Knight, Allan Mitchell, Darren Green
Brian Knight (MCSE, MCDBA) is a Senior Database Administrator at Alltel in Jacksonville, Florida, where he manages the mortgage enterprise database system. Brian focuses his developmental time on merging database technologies such as Oracle and DB2 into SQL Server, using DTS and OLAP. He also writes several weekly columns and co-runs the SQL Server area of Swynk.com (a BackOffice-focused Internet site) and writes columns for SQL Magazine.Mark Chaffin is Data Warehouse Architect for Encore Development and has developed numerous decision support systems for clients in such industries as technology, mortgage banking, retail, sports statistics, financial services, and insurance. He also has experience in clickstream analytics, data mining, transactional application architecture, Internet application architecture, database administration, and database design.
Bibliographische Angaben
- Autoren: Brian Knight , Allan Mitchell , Darren Green
- 2006, 692 Seiten, Maße: 18,9 x 23,4 cm, Kartoniert (TB), Englisch
- By Brian Knight, Mark Chaffin, Larry Bames et al.
- Verlag: Wiley & Sons
- ISBN-10: 0764584359
- ISBN-13: 9780764584350
Sprache:
Englisch
Kommentar zu "Professional SQL Server 2005 Integration Services"
0 Gebrauchte Artikel zu „Professional SQL Server 2005 Integration Services“
Zustand | Preis | Porto | Zahlung | Verkäufer | Rating |
---|
Schreiben Sie einen Kommentar zu "Professional SQL Server 2005 Integration Services".
Kommentar verfassen