Cargando…
SQL Server integration services using Visual Studio 2005 : a beginners guide /
Explains how to program and maintain databases and client-server systems using SQL to retrieve data and control operations.
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Otros Autores: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham, U.K. :
Packt Pub.,
©2007.
|
| Colección: | From technologies to solutions.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- SQL Server Integration Services Using Visual Studio 2005; SQL Server Integration Services Using Visual Studio 2005; Credits; About the Author; Acknowledgements; About the Reviewers; Preface; What This Book Covers; What You Need for This Book; Who is This Book for; Conventions; Reader Feedback; Customer Support; Errata; Questions; 1. SSIS Basics; SQL Server Integration Services; Objects Used in SSIS; The SSIS Package; The Control Flow Elements; Data Flow Components; Data Source Components; Data Transformation; Data Flow Destinations; Connection Managers; Variables; Event Handlers.
- Log ProvidersDebugging and Diagnostic Features; Summary; 2. Creating a BI Project for SSIS in Visual Studio 2005; Business Intelligence using Microsoft Products; Resources Used for Creating Projects; Creating Your First BI Project for SSIS; Launching VS 2005 and Creating a BI Project for Integration Services; Business Intelligence Project Properties; Overview of the Project Window; Canvas for Package Design; Control Flow; Data Flow; Event Handlers; Package Explorer; The Toolbox; Adding Items not Available in the Toolbox; Toolbox Items; The Solution Explorer; Getting Various Windows.
- Server Explorer WindowBookmark Window; Class View and Code Definition Windows; Object Browser; Error List Window; Output Window; Properties Window; Tasks List Window; Toolbox Window; Find Results Window; Other Windows; Debug Windows; BI Related Items in Tools/Options; Property Pages and Folders of the Project; Executing the Package and Saving the Project; Hands-On Exercises; Hands-On Exercise 1; Hands-On Exercise 2; Hands-On Exercise 3; Summary; 3. Sending Email with a SSIS Package; Hands-On Exercise One: Sending an Email Using the SMTP Server.
- Hands-On Exercise Two: How to Find Your ISP's SMTP Server?Summary; 4. Transferring Data to a Text File; Hands-On Exercise: Transferring Data to a Text File; Step 1: Creating a BI Project and Adding a Data Flow Task; Step 2: Adding Connection Manager for the DataReader; Step 3: Configuring the Source; Step 4: Adding a Flat File Destination and Establishing a Path from DataReader Source; Step 5: Configuring the Flat File Destination Component; Step 6: Build and Execute the Package; Summary; 5. Transferring Data to a Microsoft Excel File; Hands-On Exercise: Transferring Data to an Excel File.
- Step 1: Creating a BI Project and Adding a Data Flow TaskStep 2: Configuring the DataReader's Connection Manager; Step 3: Configuring the DataReader Source; Step 4: Adding a Character Map Transformation; Step 5: Adding an Excel Destination and Establishing a Path to It from the Character Map Data Flow Component; Step 6: Configuring the Excel Destination Component; Step 7: Testing the Package; Summary; 6. Data Transfer to an MS Access Database; Hands-On Exercise: Transferring Data to an Access Database; Step 1: Creating a BI Project and Adding a Data Flow Task.