SQL Server Integration Services Using Visual Studio 2005
SQL Server Integration Services
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
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?
Transferring Data to a Text File
Hands-On Exercise: Transferring Data to a Text File
Transferring Data to a Microsoft Excel File
Hands-On Exercise: Transferring Data to an Excel File
Data Transfer to an MS Access Database
Hands-On Exercise: Transferring Data to an Access Database
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
Using a Conditional Split Data Transformation
Hands-On Exercise: Splitting Data Retrieved from a SQL Server
Using an Aggregate Data Transformation
Hands-On Exercise: Using Aggregate Data Flow Transformation
Using a Data Conversion Data Flow Transformation
Hands-On Exercise: Transferring Data to an Excel File
Creating a SSIS Package with an XML Task
XML Documents Used in This Chapter
Hands-On Exercise 1: XMLTask type Diff
Hands-On Exercise 2: XMLTask Type XSLT
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
Package to Copy a Table from Oracle XE
Hands-On Exercise: Transferring a View from Oracle 10G XE to an SQL Server 2005 Database
Web Service Task to Convert Miles to Kilometres
Hands-On Exercise: Creating and Testing a Package that Uses a Web Service Task
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
On Using Event Handlers in SSIS
Hands-On Exercise: Creating a Project with Two Packages
Package that Transfers a File Using an FTP Task
Hands-On Exercise: Creating a Package with a FTP Task
Package with an ActiveX Script Task
Hands-On Exercise: Creating a Package with ActiveX Script Tasks
Example Three: Navigating to the Internet Explorer Browser
Overview of the Hands-On Exercises
Hands-On Exercise: Creating a Package with Script Tasks