SQL Server integration services using Visual Studio 2005 : a beginners guide /: a beginners guide. (©2007)

• Record Type: Book
• Further Information: Note: Jayaram Krishnaswamy ; reviewer, Anand Narayanaswamy.
• Other Names: Krishnaswamy, Jayaram; Narayanaswamy, Anand
• 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.
• Publisher Details: Birmingham, U.K : Packt Pub
• Publication Date: 2007
• Copyright Date: 2007
• Extent: 1 online resource (vii, 301 pages), illustrations
• Subjects: 005.75/85; Database management; Client/server computing; SQL (Computer program language); Relational databases; Client/server computing; Database management; Microsoft Visual studio; SQL server; COMPUTERS -- Data Processing; SQL (Computer program language); Relational databases; Client/server computing; Database management; SQL (Computer program language); Relational databases; Electronic books; Electronic books
• Languages: English
• ISBNs: 9781847193322; 1847193323; 1847193315; 9781847193315; 1281236756; 9781281236753
• Related ISBNs: 9781847193315
• Notes: Note: Includes bibliographical references and index.
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.