Description |
1 online resource (vii, 301 pages) : illustrations. |
|
text file |
Series |
From technologies to solutions
|
|
From technologies to solutions.
|
Note |
Title from title screen. |
Bibliography |
Includes bibliographical references and index. |
Summary |
Explains how to program and maintain databases and client-server systems using SQL to retrieve data and control operations. |
Contents |
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. |
Local Note |
eBooks on EBSCOhost EBSCO eBook Subscription Academic Collection - North America |
Subject |
SQL server.
|
|
SQL server. |
|
Microsoft Visual studio.
|
|
Microsoft Visual studio. |
|
Microsoft Visual studio. |
|
SQL server. |
|
Database management.
|
|
Database management. |
|
Client/server computing.
|
|
Client/server computing. |
Genre/Form |
Electronic books.
|
Added Author |
Narayanaswamy, Anand, reviewer.
|
Other Form: |
Print version: Krishnaswamy, Jayaram. SQL server integration services using Visual Studio 2005. Birmingham : Packt Pub., ©2007 9781847193315 1847193315 (OCoLC)220914329 |
ISBN |
9781847193322 (electronic book) |
|
1847193323 (electronic book) |
|
1847193315 |
|
9781847193315 |
|
1281236756 |
|
9781281236753 |
|
9781847193315 |
|