Brian Knight / Mark Chaffin / Larry Barnes / Jay Warren / Martin Young

Professional SQL Server 2005 Integration Services

Mitarbeit: Knight, Brian; Chaffin, Mark; Barnes, Larry

• Broschiertes Buch

Produktbeschreibung

* 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

Produktdetails

• Verlag: Wiley & Sons
• Seitenzahl: 850
• Englisch
• Gewicht: 1060g
• ISBN-13: 9780764584350
• ISBN-10: 0764584359
• Artikelnr.: 15172702

Autorenporträt

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.

Inhaltsangabe

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.