Professional SQL Server 2005 Integration Services

Brian Knight, Allan Mitchell, Darren Green, Douglas Hinson, Kathi Kellenberg, Andy Leonard, Erik Veerman, Jason Gerard, Haidong Ji, Mike Murphy - Collection Professional

720 pages, parution le 21/02/2006

Ajouter à une liste

Indisponible

Résumé

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

L'auteur - Brian Knight

Brian Knight, SQL Server MVP, MCSE, MCDBA, is the cofounder of SQLServerCentral.com and was recently on the Board of Directors for the Professional Association for SQL Server (PASS). He runs the local SQL Server users group in Jacksonville, Florida (JSSUG). Brian is a contributing columnist for SQL Server Standard and also maintains a weekly column for the database Web site SQLServerCentral.com. He is the author of Admin911: SQL Server (Osborne/McGraw-Hill Publishing) and coauthor of Professional SQL Server DTS and Professional SQL Server 2005 SSIS (Wiley Publishing). Brian has spoken at such conferences as PASS, SQL Connections, and TechEd.

L'auteur - Allan Mitchell

Allan Mitchell - Allan Mitchell is a Microsoft Certified, columnist in SQL Server Professional Magazine and is a regular presenter at SQL Server User Group meetings in the United Kingdom. Allan is currently a DBA lead for a multinational media company in the UK providing support for over 400 databases. In the course of his career, he has primarily worked on Microsoft based solutions using SQL Server from Version 6.5 to Version 2000.

Sommaire

Welcome to SQL Server Integration Services
The SSIS Tools
SSIS Tasks
Containers and Data Flow
Creating an End-to-End Package
Advanced Tasks and Transforms
Scripting in SSIS
Accessing Heterogeneous Data
Reliability and Scalability
Understanding the Integration Services Engine
Applying the Integration Services Engine
DTS 2000 Migration and Metadata Management
Error and Event Handling
Programming and Extending SSIS
Adding a User Interface to Your Component
External Management and WMI Task Implementation
Using SSIS with External Applications
SSIS Software Development Life Cycle
Case Study: A Programmatic Example

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Wrox Press
Auteur(s)	Brian Knight, Allan Mitchell, Darren Green, Douglas Hinson, Kathi Kellenberg, Andy Leonard, Erik Veerman, Jason Gerard, Haidong Ji, Mike Murphy
Collection	Professional
Parution	21/02/2006
Nb. de pages	720
Format	19 x 23
Couverture	Broché
Poids	1050g
Intérieur	Noir et Blanc
EAN13	9780764584350
ISBN13	978-0-7645-8435-0