PacktLib: Beginners Guide to 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

SSIS Basics

SQL Server Integration Services

Objects Used in SSIS

Summary

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

Hands-On Exercises

Summary

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

Transferring Data to a Text File

Hands-On Exercise: Transferring Data to a Text File

Summary

Transferring Data to a Microsoft Excel File

Hands-On Exercise: Transferring Data to an Excel File

Summary

Data Transfer to an MS Access Database

Hands-On Exercise: Transferring Data to an Access Database

Summary

Data Transfer from a Text File Using the Bulk Insert Task

Hands-On Exercise: Transferring Data from a Flat File to a SQL Server Database Table

Summary

Using a Conditional Split Data Transformation

Hands-On Exercise: Splitting Data Retrieved from a SQL Server

Summary

Using an Aggregate Data Transformation

Hands-On Exercise: Using Aggregate Data Flow Transformation

Summary

Using a Data Conversion Data Flow Transformation

Hands-On Exercise: Transferring Data to an Excel File

Summary

Creating a SSIS Package with an XML Task

Diff

Merge

Validate

XPATH

XSLT

XML Documents Used in This Chapter

Hands-On Exercise 1: XMLTask type Diff

Hands-On Exercise 2: XMLTask Type XSLT

Summary

Creating a SSIS Package to Access Folders and Files

Hands-On Exercise: Copying a File from One Folder to Another and Sending it using the Send Mail Task

Using Precedence Constraint to Send Mail

Summary

Package to Copy a Table from Oracle XE

Hands-On Exercise: Transferring a View from Oracle 10G XE to an SQL Server 2005 Database

Summary

Web Service Task to Convert Miles to Kilometres

Hands-On Exercise: Creating and Testing a Package that Uses a Web Service Task

Summary

Package that Transfers a Database from One SQL Server to Another

Hands-On Exercise: Creating and Testing a Package that Uses a Transfer Database Task

Summary

On Using Event Handlers in SSIS

Hands-On Exercise: Creating a Project with Two Packages

Summary

Package that Transfers a File Using an FTP Task

Hands-On Exercise: Creating a Package with a FTP Task

Summary

Package with an ActiveX Script Task

Hands-On Exercise: Creating a Package with ActiveX Script Tasks

Example Three: Navigating to the Internet Explorer Browser

Summary

Package with a Script Task

Overview of the Hands-On Exercises

Hands-On Exercise: Creating a Package with Script Tasks

Summary

Package with Maintenance Plan Tasks

Summary